Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Conditional formatting problem

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)


Super User
Super User

@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",




How to do conditional formatting by measure and apply it on pie?

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors