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 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.

 

 

dedelman_clng's avatar
dedelman_clng
Community Champion
2 months ago

parry2k - when giving an "else" value, the 0s do appear with the "else" color. Is this possibly a bug, or a problem in my model/code?

 

I've never seen this behavior before, but admittedly almost all of the times I've used conditional formatting it was based on the value of the measure, not on one of the column headers.

 

David