Forum Discussion

dedelman_clng's avatar
dedelman_clng
Community Champion
2 months ago
Solved

Conditional Formatting breaks with "forced" zero

I have a relatively simple matrix display with a single measure, on which I am using Conditional Formatting.    Threshold Count UC-MV = var __ThisType = SELECTEDVALUE(Event_Tbl[UC]) var __Cnt = S...
Need Help
  • parry2k's avatar
    parry2k
    2 months ago

    dedelman_clng I think the issue might be this condition: can you test by adding color for catch all and see if blank / 0 shows in that color

     

    Summary Color = var __Train = SELECTEDVALUE(DimTrain[Train])
return 
    SWITCH(__Train,
            "Train 1", "#BFDEF0",
            "Train 2", "#F8CA93",
            "Train 3", "#C4C4C6", "Red"
)

     

    In the attached file, I tried to reproduce your issue, but the conditional formatting for blank (shown as zero) is working fine.

     

     

  • parry2k's avatar
    parry2k
    2 months ago

    dedelman_clng I don't think it is a bug; it seems like a modelling-related issue. It will be very hard to pinpoint without knowing all the modelling details. 

parry2k's avatar
parry2k
Super User
2 months ago

dedelman_clng I don't think it is a bug; it seems like a modelling-related issue. It will be very hard to pinpoint without knowing all the modelling details.