Forum Discussion
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...
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!
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!
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.