I have table with a budget to actual % measure that I want to be in red if it is greater than 100%. Meaning % over budget. I tried using font color scales with no success. See image. I have tried using 100 instead of 1 and that does not work.
What am I doing wrong?
Thanks,
Joe
hI @Black783,
How do you have the measure/column formatted?
I have made a sample with a column as % and it works with 1 as you have:
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Make the second part of your rule something outrageous like 999.
Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: DAX For Humans
DAX is easy, CALCULATE makes DAX hard...
hI @Black783,
How do you have the measure/column formatted?
I have made a sample with a column as % and it works with 1 as you have:
Regards,
MFelix
Regards
Miguel Félix
Did I answer your question? Mark my post as a solution!
Proud to be a Super User!
Check out my blog: Power BI em Português
Helpful resources
Power BI Dataviz World Championships
The Power BI Data Visualization World Championships is back! It's time to submit your entry.
Power BI Monthly Update - January 2026
Check out the January 2026 Power BI update to learn about new features.
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
