Forum Discussion
Solved
How to put a conditional formatting into the matrix column
I would like to put a conditional formatting in my matrix per column instead of the entire dataset. Is It possible?
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.
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.
Appreciate It, Anonymous!
