Forum Discussion
HOW TO: conditional format table with multiple text columns
Hello All, I was wondering if there is a way to conditional format multiple text columns to yield the following color scheme in a table? The only way I can think of is creating a measure for each...
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.
