Color specific Values in a series (Community)

View the original community article here

Last tested: Jan 15, 2020
 

Want to create different colors on a single series of data based on a specific dimension value?

Create table calculations that use if statements to satisfy a certain condition. EG: if(${value) = 'TRUE', ${measure}, null)
If true, we show the measure, if else, we show null.
Then, we hide the null values from the visualization by clicking the gear --> edit --> plot. (You may have to run the explore again for the (Plot null values toggle to show up).

Table Calc 1

Table Calc 2

Turn Plot Null Values to Off on Visualization

What the end explore looks like:

METHOD 2 [Custom Palette]

1. Get the # of series in your chart
2. Go to the edit panel and click the Custom Palette option which will allow you to specify the colors via a comma separated list.
   1. Each color at the position will link to the position in the series. So in this case, we made the 4th series blue, hence the 4th value on the list is the color