Knowledge Drop

Color specific Values in a series

Userlevel 4

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

Screen Shot 2020-01-15 at 4.47.16 PM.png


Table Calc 2

Screen Shot 2020-01-15 at 4.47.31 PM.png

Turn Plot Null Values to Off on Visualization

Screen Shot 2020-01-15 at 4.47.50 PM.png

What the end explore looks like:

Screen Shot 2020-01-15 at 4.47.38 PM.png



METHOD 2 [Custom Palette]

Screen Shot 2020-06-12 at 9.53.28 AM.png

  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


This content is subject to limited support.                



0 replies

Be the first to reply!