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,
In the Query Editor, you should select the first 3 columns and then use the "Unpivot other columns". You will then have to write only 3 measures - one each for Out, Pend and Comp.
Hope this helps.
Hi Ashish,
Will that affect the layout? It is important that the layout be this specific way
Hi,
I don;t think transforming the data in a certain way will affect the desired result. Please try.