Forum Discussion
How to put a conditional formatting into the matrix column
Hi luccaguimaraes ,
1. Please refer to this blog o change the quick calculation to a measure instead.
2. Then you could use SWITCH() to set conditional formatting based on the measure value , like:
Color Measure = SWITCH(TRUE, [Measure] <0.2,"Red",[Measure]>=0.2 && [Measure]<=0.5,"Green","Yellow")Output:
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Community ChampionYou can set it per measure. It looks like you have your columns as a field that is in the Columns section. You cannot set conditional formatting on a specific column based on that field.
- AlexisOlson
Super User
Well, not directly anyway. It is possible to write a measure that takes into account the column context to use in the conditional formatting. There is still only one field you're setting conditional formatting on but allows for additional flexibility.
