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...
amitchandak
Super User
Super UserMary_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