Forum Discussion

stuross1129's avatar
stuross1129
Frequent Visitor
7 years ago
Solved

Conditional format color of background based on text value, across multiple columns

I am trying to shade the background color Red on any cells in a table that contain the text value = "No" and green for any values = "Yes".   Is there a simple way to do this with a single expressio...
Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi stuross1129,

     

    If you use a Table visual to show data, you have to set conditional background colors for each column one by one. For example, to set conditional formatting for Step1, please create a measure first. If you have N columns, then, you need N mesaures.

    Measure for step1 = IF(SELECTEDVALUE(Table2[Step1])="Yes",1,0)

     

    As a workaround, you can unpivot table first in Query Editor mode, then, use a Matrix to analyse data.

     

     

    Measure 2 = IF(SELECTEDVALUE('Table2 (2)'[Value])="Yes",1,0)

     

    Best regards,

    Yuliana Gu

v-yulgu-msft's avatar
v-yulgu-msft
Icon for Microsoft Employee rankMicrosoft Employee
7 years ago

Hi stuross1129,

 

If you use a Table visual to show data, you have to set conditional background colors for each column one by one. For example, to set conditional formatting for Step1, please create a measure first. If you have N columns, then, you need N mesaures.

Measure for step1 = IF(SELECTEDVALUE(Table2[Step1])="Yes",1,0)

 

As a workaround, you can unpivot table first in Query Editor mode, then, use a Matrix to analyse data.

 

 

Measure 2 = IF(SELECTEDVALUE('Table2 (2)'[Value])="Yes",1,0)

 

Best regards,

Yuliana Gu