topic Conditional Formatting- Positive & Negative Variances in Custom Visuals Development Discussion

Conditional Formatting- Positive & Negative Variances

BarneyRubble — Wed, 19 Mar 2025 16:17:30 GMT

Hi,

I am wondering if it is possible to do RAG status formatting based on a range of variances.

Any positive variance = Green

Negative variance zero to minus 5 = Amber

Negative variance below minus 5 = Red

I know how to do just the Red & Green but I don't know how I include the Amber.

Re: Conditional Formatting- Positive & Negative Variances

Greg_Deckler — Wed, 19 Mar 2025 17:13:15 GMT

@BarneyRubble There is a setting to include a third color for gradients in conditional formatting. That's one way or you can do rules and do it that way or you can create a measure that returns the correct color hex code.

Re: Conditional Formatting- Positive & Negative Variances

Deku — Thu, 20 Mar 2025 00:16:00 GMT

Rules look like this

Re: Conditional Formatting- Positive & Negative Variances

BarneyRubble — Thu, 20 Mar 2025 07:53:00 GMT

Hi, Thanks for responding. I probably should have provided more details in my initial post. The visual I am using is the MS KPI, it is based on Actual v Budget. The default is Green for a positve variance (actual is lower) and Red for a negative variance (actual is higher). I have highlighted the variance in the snip below. What I want to do is maintain the Green for any positive variance so from 0 - 100, I would like a negative variance between 0 to -5 to be Amber, then anything below -5 to be Red. I hope that makes sense.