Forum Discussion
Conditional formatting in matrix
I need to see conditional formatting only one one hierarchy level in a matrix - how can I accomplish this? I have 4 levels. I want ONLY Level 2 to have conditional formatting, and need that conditio...
amitchandak
Super User
Super UserAnonymous , Create a measure like
Switch( True(),
max(Table[ Level 2]) >=0 && max(Table[ Level 2]) <=5 , "green",
max(Table[ Level 2]) >=5 && max(Table[ Level 2]) <=8 , "yellow",
"red"
)
Use in conditional formatting using the field value option
How to do conditional formatting by measure and applying 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