Skip blank values based on the color condition

hi fbittencourt ,

Glad the last version helped a bit! I think the key with Power BI formatting and blanks is to be really explicit with how you handle them, since visuals will ignore BLANK() and just show default formatting.

Try this version for your measure, it's a bit cleaner and should skip formatting whenever there’s missing data, plus it keeps your color logic clear:

VAR MEP_Planifie = MAX(REF_PROJET[MEP Date])
VAR colorMEP =
    IF(
        ISBLANK(MEP_Planifie),
        BLANK(),
        IF(MEP_Planifie < [Date_jourM-1], "#E66C37", "#000000")
    )
VAR colorProgress =
    IF(
        ISBLANK([% Avancement projet]),
        BLANK(),
        IF([% Avancement projet] > 0.9, "#E66C37", "#000000")
    )

RETURN
SWITCH(
    TRUE(),
    // Skip formatting if either color is blank
    ISBLANK(colorMEP) || ISBLANK(colorProgress), BLANK(),
    // Both conditions orange = blue
    colorMEP = "#E66C37" && colorProgress = "#E66C37", "#0000FF",
    // Otherwise use main color
    NOT(ISBLANK(colorMEP)), colorMEP,
    NOT(ISBLANK(colorProgress)), colorProgress,
    "#000000"
)

By checking ISBLANK up front, Power BI will just leave the cell with default formatting if there’s no data, which is usually what you want. Multiple Conditions: If both conditions are met, you’ll get blue; otherwise, your normal rules apply. Still Not Working? Sometimes “blank” in Power BI is actually an empty string or a hidden value, so double-check your source fields if it’s still acting weird (using LEN or TRIM can help diagnose).