Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
82 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |