Conditional formatting in matrix

[Anonymous]

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.

[amitchandak]

@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