Conditional Formatting

[nh27]

Hi all,

I am trying to get my conditional formatting set so that if the % is 100 it shows green, all other conditions are working as specified.

Anyone know how I can can basically show if anything is above 100% it should be green? At the moment if the value is 100% it shows red, I can't seem to set a condition just for >=100 then green.

Any help appreciated.

[Anonymous]

I would suggest you do what @mh2587 said and also: 

- instead of percentage, select number

- order from lowest to highest values

- use >= and > to be sure you're including all values. Your rules are excluding some numbers like the range [0.9391, 0.9399]  

[mh2587]

Give the in number like 94% to 0.94 ,99.8% to 0.998 etc then try

[nh27]

Thanks but unfortunately this did not work 😞

[mh2587]

Did you change the option from percentage to number in dropdown menu

[nh27]

I did, see below:

[Anonymous · Accepted solution]

HI @nh27,

I'd like to suggest you try to create a measure expression for the color formatting, you can enable conditional formatting with 'field value' mode on the 'value' field:

Apply conditional table formatting in Power BI - Power BI | Microsoft Docs

Solved: Re: Measures for conditional formatting are not av... - Microsoft Power BI Community

Regards,

Xiaoxin Sheng