Forum Discussion

EpicTriffid's avatar
EpicTriffid
Helper 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!

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi EpicTriffid 

 

The only way I could make it works was doing the following metric:

TarKPIColour = SWITCH (

   SUM([Tar Diff]) >= -0.005, "#30a316",

   SUM([Tar Diff])  <-0.005, "#d10a14",

...)

 

 

EpicTriffid's avatar
EpicTriffid
Helper IV
6 years ago

hi Anonymous 

 

Thanks for that. I had to use SUMX in order to get the measure, but the visualisation failed saying it can compare boolean values with text values. Not sure where it's getting hung up...