Conditional formatting not giving expected output

[RingoSun]

Above is my table, in the Color column the value is 0 if the Score is equal to or greater than the Expected column. Otherwise the value will be 1 if it is above the Minimum but below the Expected. The Score is basically just Numerator divived by Denominator.

Basically, if the Score meets or exceeds the Expected %, then the color should be green. But if it is below the Expected % but above the Minimum % then the color should be Yellow.

It can be seen above that January 2021 is 89% which means it meets the minimum so the Yellow color is correct. But for September 2021 it is 90%, it meets the Expected % but the color is still Yellow.

Here are the rules I have applied.

Can anyone help me troubleshoot this and how to get the correct colors assigned?

PBIX

[Anonymous · Accepted solution]

Hi @RingoSun,

Perhaps you can try to use write a measure formula to compare values and return color code, then you can use this expression and formula condition in conditional formatting.

Apply conditional table formatting in Power BI - Power BI | Microsoft Learn

Regards,

Xiaoxin Sheng

[JorgePinho]

Can you show the conditional formating rule you applied?

[RingoSun]

@JorgePinho 

Here it is

[keshavagrawal27]

Hello @RingoSun ,

I am unable to access your PBIX file.

Please check your "Field formatting" and check if it is mapped with the current variable/column name.

If it helps you then please mark it as solution.

Regards,

Keshav Agrawal