Forum Discussion
Conditional Formatting not working
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 ,
We can try to use the following measure as the new field value to meet your requirement:
ColorMeasure =
IF (
[Int Tar Diff] <> ""
|| [Tar Diff] <> "",
SWITCH (
VALUES ( KPIs_COMBINED_RESHAPED[KPI] ),
IF ( [Int Tar Diff] >= 0.5, "#30a316", "d10a14" ), IF ( [Tar Diff] >= -0.005, "#30a316", "d10a14" )
),
""
)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.
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.