Having trouble with conditional formatting with percentages greater than 100%

[kitcatnj]

Hello. I am still rather new to power bi. I can't seem to get my conditional formatting correct. I have played with it using number vs percentage with no luck. Keep in mind, this is measure that can have a percentage > 100%, but when you do percentage in power bi, it will max at 100 in conditional formatting. So i even played with a combination of percentages and then changing the last with MAX of (max number)

It seems like it should be very simple to accomplish.

IF the number is < 2.5% then it should be green.

If it is >= 2.5%, it should be red.

Thank you for any help you can give. 

As percentage

 

As a number

[Manoj_Nair · Accepted solution]

@kitcatnj - try this, and let me know if this fix your problem. Thanks

[kitcatnj]

@Manoj_Nair

Thank you! That did it! Many Thanks!!!!!

[Mikelytics]

Hi @kitcatnj 

Can you please try it like in the second picture with "number" and then put in

0       0.25

0.25   Max

Best regards

Michael

-----------------------------------------------------

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. Appreciate your thumbs up!

@ me in replies or I'll lose your thread.

-----------------------------------------------------

LinkedIn

[kitcatnj]

Thank you so much for the quick reply. It didn't seem to work though. Once i change it and go back in, the when i select max number it turns back into % when i go back into it.