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

[Mk60]

I have created table with calculated columns 1-9, (attachment#1), and I know that my condition Rules work fine b/c I can see that my percentages are matching the actual reporting calculations for each month, (Jan23-Nov23). Example-column 8 shows 280.06% in red-orange color which I assigned, (as in attachment#2). So, Rules for all of the columns1-9 work as expected. However, when I try to do conditional formatting to my column H, which is based on the data from my column 8, and should display specific text, it does NOT show accurate name, which for Aug23 should be "Caution" in column H, instead of Watch,(attachment#3).And I have the same issue in column I where only top 2 rows in yellow should be yellow "Watch", but everthing below should be showing "Caution" in red color. I can not see what I may be doing wrong here, since all green cells "Appetite" seem to be working fine. I used this simple DAX calculation to create my new Masures, (attachment#4), and I am not sure if that calculation may be the problem, since it is working ok for "Appetite" category? I hope I provided sufficent information here. Please advise. 

#1

#2

#3

#4

[v-binbinyu-msft · Accepted solution]

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.

[v-binbinyu-msft · Accepted solution]

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.

[Mk60 · Accepted solution]

Hi there,

PREVIEW

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