Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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
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
Can you show the conditional formating rule you applied?
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
User | Count |
---|---|
73 | |
70 | |
38 | |
24 | |
23 |
User | Count |
---|---|
96 | |
94 | |
50 | |
42 | |
40 |