Forum Discussion

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago
Solved

Conditional Formatting not working

I'm trying to set conditional formatting in a table. Because of the different data types, two fields (Tar Diff and Int Tar Diff) have been combined in a measure with the correct formatting so that th...
Need Help
  • EpicTriffid's avatar
    EpicTriffid
    6 years ago

    Hi v-lid-msft,

     

    Unfortunately that just made everything blank in terms of colour!

     

    I did, however, find a solution:

     

    TarKPIColour = 
IF ([Int Tar Diff] <> "" || [Tar Diff] <> "",
IF ([Tar Diff] >= -0.005 && [Int Tar Diff] >= 0.5, "#30a316", "#d10a14"))

    Not entirely sure why, but it works!

EpicTriffid's avatar
EpicTriffid
Icon for Helper IV rankHelper IV
6 years ago

Hi v-lid-msft,

 

Unfortunately that just made everything blank in terms of colour!

 

I did, however, find a solution:

 

TarKPIColour = 
IF ([Int Tar Diff] <> "" || [Tar Diff] <> "",
IF ([Tar Diff] >= -0.005 && [Int Tar Diff] >= 0.5, "#30a316", "#d10a14"))

Not entirely sure why, but it works!

v-lid-msft's avatar
v-lid-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi EpicTriffid ,


Glad to hear that you have resolved your problem. Would you please kindly mark your sharing solution as an answer so that it can benefit more users?

 

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.