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 conditional formatting to remain no matter where the hierarchy is drilled to.
Level 1 = Role
Level 2 = Resource
Level 3 = Stage
Level 4 = Project
If the values in Level 2 are 0 to 5, it should be green. If the values are 5-8, yellow. If 9-10, red.
I have tried to piece this together with ISINSCOPE but I cannot figure it out.
1 Reply
Anonymous , 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
