How to set dynamic conditional formatting on color of gauge chart?

[v-ankitgupta]

In my PowerBi report, I have added a guage chart, and applied conditional formatting, based upon 2 values:

• Target
• Actual Value

If the actual value is more than target, then the gauge chart will be green otherwise red. Now, based upon the data selected in a multi select drop down, the values of both 'Target' and 'Actual value' changes. Therefore, I want to have a dynamic conditional formatting for the guage chart where the conditional formatting for color is applied correctly according to different targets and their respective actual values.

For example:

Target;	Actual Value;	Color of Chart
85	84	Red
77	79	Green
65	71	Green

However, as displayed in the attached screenshot, the highlighted box expects a hardcoded numeric value. Please advise how to achieve this. Thanks in advance.

[v-jianboli-msft · Accepted solution]

Hi @v-ankitgupta ,

Please try:

Color = IF(SUM('Table'[Actual Value;])>SUM('Table'[Target;]),"Green","Red")

Final output:

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-ankitgupta]

It worked Jianbo, Thank you very much.