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