Forum Discussion
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...
amitchandak
Super User
Super UserJuanpablocl , 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/1682539
https://amitchandak.medium.com/power-bi-where-is-the-conditional-formatting-option-in-new-format-pane-66e0afcb15f3