Forum Discussion
HOW TO: conditional format table with multiple text columns
Hi Anonymous ,
According to your description, here’s my solution.
1.Unpivot columns of “P1,P2,P3”.In this case, the layout of the data view will change, however you can also use a duplicated new table to achieve it .
2.you only need to write one measure:
Color = SWITCH(MAX('Table (2)'[Value]),"OUT","RED","COMP","YELLOW","PEND","GREEN")
3.Alough the data view differs, the report view still can remain the same by a matrix like this.
Best Regards,
Community Support Team _ kalyjIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
According to your description, here’s my solution.
1.Unpivot columns of “P1,P2,P3”.In this case, the layout of the data view will change, however you can also use a duplicated new table to achieve it .
2.you only need to write one measure:
Color = SWITCH(MAX('Table (2)'[Value]),"OUT","RED","COMP","YELLOW","PEND","GREEN")
3.Alough the data view differs, the report view still can remain the same by a matrix like this.
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
How come when i drag region, contact, and order into rows into a matrix doesn't show up like how you're doing it. It only shows the region. The contact, and order do not show up right next to it as yours do.
Hi Anonymous ,
You should click on the "+" sign, it will unfold.
I attach my sample below for reference.
Best Regards,
Community Support Team _ kalyj