Calculated Column conditional formatting-works for some but not for all columns??

Hi Mk60 ,

Please try create a column with below dax formula:

Column H =
VAR _a = [Column 8]
VAR _b =
    SWITCH (
        TRUE (),
        _a <= 2.60, "Appetite",
        _a > 2.60
            && _a <= 2.80, "Watch",
        _a > 2.8
            && _a <= 3.00, "Caution",
        _a > 3.00, "Limit"
    )
RETURN
    _b

Add a table visual with table fields and set conditional formatting:

Please refer the attached .pbix file.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi there,

Worked perfectly!! Just wanted to express my gratitude for your time and consideration. I was aware of the Switch option, but never seen or used one with VAR before. Once again, thank you so very much. Greatly appreciated!

mk