Conditional formatting issue

[Anonymous]

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!

[HotChilli]

If you post the pbix and put a link here, I'll have a look at it

[Anonymous]

Misunderstood your previous explanation, but have marked as solution now!

[HotChilli · Accepted solution]

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

[Anonymous]

Unfortunately no luck! Still showing the same thing