Forum Discussion
Matrix Conditional Formatting for row value which is text
Hi Richard_Halsall ,
In order to make troubleshooting and give you a suitable solution quickly, could you please provide the following info?
1. Some raw data with Text format(exclude sensitive data)
2. If the field RoleFilledColour is a calculated column, please provide the related formula
3. How did you set your matrix visual? (Fields option settings)
4. What's your expected result? Do you want to make the backgroud color is red if the value is "No Technician", otherwise, green?
Best Regards
Richard_Halsall , Prefer to create a color measure, not column
examples
Measure =
Switch(true(),
max(Table[Column]) = "R1" , "Red" ,
max(Table[Column]) = "R2" , "Green" ,
max(Table[Column]) = "R3" , "Pink "
)
or
Switch( True() ,
[Percent] =1 , "Green"
[percent] <.75 , "red",
[percent] <.99 , "Yellow"
)
amitchandak Hi, thanks for the reply I have just implemented the measure and the unfortunately the results are the same
