Solved: Color code a % Measure

Black783 · ‎06-04-2018

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

MFelix · ‎06-04-2018

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

View solution in original post

Greg_Deckler · ‎06-04-2018

Make the second part of your rule something outrageous like 999.

@ 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!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...