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 isn't working
Logic:
Result:
TIA for any help!
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
4 Replies
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
If you post the pbix and put a link here, I'll have a look at it