Forum Discussion

mofai's avatar
mofai
Frequent Visitor
7 years ago

Conditional formatting based on 2 columns

Hi All,

Conditional formatting based on 1 column field and calculated measure

i m trying to implement a conditional formatting, to change the background color of a matrix cell.

My code is 

Condition_first_reply_time_50 = SWITCH(TRUE();
FactTickets[requesttyp]="question" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="change" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="service" && [First Reply Time (hrs)50%] >= 8; "Red";
FactTickets[requesttyp]="incident" && [First Reply Time (hrs)50%] >= 4 ; "Red";
"#83BC00")
21.7  -> is green
 
but it didnt work , i dont know why, by question , value of 21.7 i got the wrong color (green), should be red.

 

 
Thanks for your help!
Need Help

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi mofai ,

     

    I tested with above formula, it set conditional colors as expected.

     

    Best regards,

    Yuliana Gu