Conditional formatting problem

[Juanpablocl]

I am applying a conditional format based on a Measure called "% Avance Folios". I want it to be green if its over 90%, yellow if its between 70% and 90%, and red if its below 70%. No matter that kind of conditional formatting I use (icons, background/font color) it is applying the color green for values below 90%. Can I get some help?

Example attached:

(I also tried using >=90% & <100%; same outcome)

[amitchandak]

@Juanpablocl , if this is a percent measure you need to use the Number in the selection, not percent. And use a number like .9 for 90% (if you have not multiplied it by %)

Same way you can create a measure and use that using field value option

Switch( True(),

[% Avance Folio] > .9, "Green",

[% Avance Folio] > .7, "Yellow",

"Red"

)

How to do conditional formatting by measure and apply it on pie?
https://www.youtube.com/watch?v=RqBb5eBf_I4&list=PLPaNVDMhUXGYo50Ajmr4SgSV9HIQLxc8L
https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/...
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pan...