How to apply conditional formatting to matrix values & display all values

[Mary_789]

Hello,

I have a matrix that drills down to 4 hierarchies (Brand, Vehicle, Type, Part). This data is displayed in rows. In the columns, I am displaying test level and values display status(0,1,2,3,4) 

The issue I am having is that it only shows 'FIRST Status' in the values field and the conditional formatting will not work. 

For example, I assigned Red if value is 0, green if value is 1, Blue if value is 2.. But all the fields are green.

Can I get some help with this?

Thanks.

[Mary_789]

Thank you! I was able to format by field value using this measure.

But now when I collapse the hierachies, I see data with the formatting not assigned and it is a mix of values. How is it determining what value to apply when collasped? 

Expanded:

One level collapsed:

2 level collapsed: 

[amitchandak]

@Mary_789 , You can create a color measure and use that in conditional formatting

example

Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)

How to do conditional formatting by measure and apply it on pie? : https://youtu.be/RqBb5eBf_I4

Create Table, Matrix, Bar, Pie, Line, Conditional formatting- https://youtu.be/BIwX2I7gF5Q?t=214