Forum Discussion

SaCvP125's avatar
SaCvP125
Frequent Visitor
8 years ago
Solved

Enter a background colour based on another column value

Hi guys,   I've the following table: SLA Description Target_Value Result Flag Time to Respond 80% 83% 1 Time to Resolution 95% 79% 0   What I'm trying to do is when my Resul...
Show and Tell
Tips and Tricks
  • v-huizhn-msft's avatar
    v-huizhn-msft
    8 years ago

    Hi SaCvP125,

    As what you said, I create calculated column using the formula.

    Flag = IF(Table1[Result]>Table1[Target_Value],1,0)



    Then you create a visual, select all the fields needed to show. Right click the Flag column->Conditional formatting->Front color scales. Then set the minimum as 0, the maximum as 1. 

    conditional formatting for Flag columnSet the color of font in Flag
    You will get expected result as follows.



    Best Regards,
    Angelia

     

v-huizhn-msft's avatar
v-huizhn-msft
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Hi SaCvP125,

As what you said, I create calculated column using the formula.

Flag = IF(Table1[Result]>Table1[Target_Value],1,0)



Then you create a visual, select all the fields needed to show. Right click the Flag column->Conditional formatting->Front color scales. Then set the minimum as 0, the maximum as 1. 

conditional formatting for Flag columnSet the color of font in Flag
You will get expected result as follows.



Best Regards,
Angelia