Forum Discussion
Anonymous
3 years agoNot applicable
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...
- 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
HotChilli
3 years agoCommunity Champion
If you post the pbix and put a link here, I'll have a look at it
Anonymous
3 years agoNot applicable
Misunderstood your previous explanation, but have marked as solution now!