I used following measure for Actual Vs Budget with formatting in it.
RLU Act Vs Bud =
VAR Currentitem = SELECTEDVALUE(RLUKeyMeasures[Retirement Living Unit])
CurrentItem = “Occupancy” , FORMAT([RLU Act Occupancy%]-[RLU Bud Occupancy%], “0.0%”),
CurrentItem = “Vacant Units”, FORMAT([RLU Act Vacant Units]-1+[RLU Bud Vacant Units], “0”),
CurrentItem = “Vacant units recurrent charges”, FORMAT([RLU Act Vacant Units Recurrent charges]-1+[RLU Bud Vacant Units Recurrent charges], “0,000”),
I would like to have conditional formatting based on the result. Because it became text, I have to select based on field in conditional formatting.
As per attached highlighted field for variances, how can I add font colour and icon with conditional formatting.