cancel
Showing results for 
Search instead for 
Did you mean: 

Colors attached to specific result values

MateuszCz
Rocketeer

Is there any way to fix colors to specific check result? We use mostly pie charts and for each of them we do validity and emptiness checks. From what we understand, colors are assigned in left to right order to results from top to bottom of the logic. We are trying to bind specific color to specific result (for example: green to "valid", red to "invalid", "missing" and "test not required"). The problem is when not all results are occuring for particular chart (for example, there are no records with "empty" result), then order of color assignment changes and for example, "valid" lands on red.

Is there any way to bind those colors specifically to each logic result?

Please see screenshot to illustrate. Appreciate all your help and feedback!

1 REPLY 1

JoeM
Community Manager
Community Manager

This could be achieved using conditional formatting. 

  • Select the measure
  • Selection conditional formatting for color
  • Set the dimension to be formatted (Min/Max for aggregation type)
  • Then add dimensional values and assign the associated colors