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 _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.