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.

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
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

    Hi,

    I get the syntax error "Too many arguments were passed to the MAX function. THe maximum argument count for the function is 2" when using your recommended measure

    Color = SWITCH(MAX('Table (2)'[Value]),"OUT","RED","COMP","YELLOW","PEND","GREEN"). Am I doing something wrong?

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

      Hi Anonymous ,

      According to your error message, I suggest you check your formula again, whether you add bracket after MAX function like below.

      MAX('Table (2)'[Value])

      Best Regards,
      Community Support Team _ kalyj

  • 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