Forum Discussion
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.
4 Replies
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!
You 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.
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.
