topic Re: Colors attached to specific result values in Dashboards & Analytics Discussions

Colors attached to specific result values

MateuszCz — Mon, 26 Jan 2026 10:51:11 GMT

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!

Re: Colors attached to specific result values

JoeM — Tue, 27 Jan 2026 21:51:49 GMT

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

Re: Colors attached to specific result values

adam_sicora — Wed, 25 Mar 2026 18:31:44 GMT

Is it possible to do this or similar for a bar chart with a coloring dimension? Specifically using a stacked column & line visual.

The column chart is colored based on status, Closed being green, Open is yellow, and Late is red. But when all open values are filtered out, Late values go yellow. Not seeing a "Conditional Formatting" option for this column section.