Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Colour Formatting Dax - SWITCH function

Hi Guys    I keep hitting a brick wall, I have this formula but I keep getting errors OR it only picks up the first condition "Green" and the "Persian Blue" for all my completed items.   I am try...
Need Help
  • AlB's avatar
    AlB
    5 years ago

    Hi Anonymous 

    Background colour =
SWITCH (
    TRUE (),
    [DAX Status] = "Complete", "Persian Blue",
    AND ( [% remaining - Report] >= 0, [% remaining - Report] < 0.4 ), "Green",
    AND ( [% remaining - Report] >= 0.41, [% remaining - Report] < 0.6 ), "Lemon",
    AND ( [% remaining - Report] >= 0.61, [% remaining - Report] < 0.79 ), "Orange",
    [% remaining - Report] > 0.8, "Red"
)

     

    Please mark the question solved when done and consider giving kudos if posts are helpful.

    Contact me privately for support with any larger-scale BI needs, tutoring, etc.

    Cheers