Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Conditional formatting issue

Hi all, I'm having issues with conditional formatting in a table and a matrix. My target: >= 90% GREEN >= 80% AMBER <= 70% RED   Is there an issue with my logic? I don't understand why this is...
  • HotChilli's avatar
    3 years ago

    Looks like your measure is a percent but you are using 'percent' in the formatting rules so powerbi will be trying to work out the rules based on a percentage using the min and max values.  I don't think you want that.

    You probably want to use Number and then put the values as decimals , for example 90% is 0.9