Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hello!
I need some help with the formatting of font color, please. I have a Matrix table for KPI's.
Everything below the target should be red, everything about green.
Below you can see the table and my setting for the font color and i dont understand, why the KPI "93,7%" is red.
The target is 90%, so it seems that i did something wrong. Thanks in advance for your help!
Solved! Go to Solution.
The "Percent" copmpare is looking at the portion of the dataset, not the output of the measure. Change your compare to look at the number rather than the percent. .9 = 90%:
The "Percent" copmpare is looking at the portion of the dataset, not the output of the measure. Change your compare to look at the number rather than the percent. .9 = 90%:
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 38 | |
| 36 | |
| 33 | |
| 32 | |
| 28 |
| User | Count |
|---|---|
| 129 | |
| 88 | |
| 79 | |
| 68 | |
| 63 |