Forum Discussion

Black783's avatar
Black783
Frequent Visitor
8 years ago
Solved

Color code a % Measure

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 ...
Tips and Tricks
  • MFelix's avatar
    MFelix
    8 years ago

    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

MFelix's avatar
MFelix
Super User
8 years ago

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

Black783's avatar
Black783
Frequent Visitor
8 years ago

It worked once I multiplied by 100 and left the value at 1.

 

Thanks,

 

Joe