Forum Discussion
How to apply conditional formatting to matrix values & display all values
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.
2 Replies
- amitchandak
Super User
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
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:
