Forum Discussion
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...
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
HotChilli
Community Champion
Community ChampionLooks 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
Unfortunately no luck! Still showing the same thing