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 using 100 instead of 1 and that does not work.

 

What am I doing wrong?

Thanks,

Joe

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

3 Replies

  • 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

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    8 years ago

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