Forum Discussion
Fusilier2
Helper V
Helper VConditional formatting help
I have this measure that calculates the difference between This month and the previous month: Headcount Excl Casuals month on month = HR_data[Headcount excl casuals Current Month]-HR_data[Headcount...
For some reason its working now. I deleted the suggested rules and added some new one's in.
SamWiseOwl
Super User
Super UserHi Fusilier2
Have you considered using a measure to do the formatting?
Icon Measure =
var Diff = [Headcount Excl Casual Month on Months] --stores the measure result
Return
Switch(
TRUE()--test if the following is true
,Diff < 0 , "🔴" --Use Windows + . for the emoji keyboard
,Diff = 0, "🟡"
,Diff > 0, "🟢"
)
As for why it is showing as percentage only.
Is there any formatting being applied to the measure that might be confusing it?