Forum Discussion
Conditional formatting not giving expected output
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?
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
4 Replies
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
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
Can you show the conditional formating rule you applied?
