LinkedIn
Twitter
Knowledge Drop
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]
- Get the # of series in your chart
- Go to the edit panel and click the Custom Palette option which will allow you to specify the colors via a comma separated list.
- 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
This content is subject to limited support.