Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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. 

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
4 years ago

Hi Anonymous ,

You should click on the "+" sign, it will unfold.

I attach my sample below for reference.

Best Regards,
Community Support Team _ kalyj