topic Re: Problem with SWITCH to change colors in DAX Commands and Tips

Problem with SWITCH to change colors

Louis66 — Wed, 19 Oct 2022 23:01:55 GMT

Hello,

I try to change the color using a measure, but without much success. Basically, my condition does not work :

Normally, the "Sugar" should show in Red... but everything shows in Orange.

Can someone help me ?

Regards,

Louis

lukiz84 — Thu, 20 Oct 2022 02:58:54 GMT

Just for testing purposes, can you add your Colour measure to the matrix next to Cookie Type and see if it returns Red/Orange?

Jayee — Thu, 20 Oct 2022 04:34:06 GMT

try below DAX Measure

colour =
SWITCH (
SELECTEDVALUE ( 'Cookie Types'[Cookie Type] ),
"Sugar", "Red",
"Orange"
)

lukiz84 — Thu, 20 Oct 2022 04:46:25 GMT

?! that's the same as the IF statement.

v-jianboli-msft — Thu, 20 Oct 2022 08:30:55 GMT

This issue has been submitted internally.

Internal ICM ID: 343098936

Please be patient to wait for fixing. If there is any news, I will update it here.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Louis66 — Thu, 20 Oct 2022 10:05:00 GMT

Hello,

Unfortunately this DAX Measure does not work either - please see this screenshot :

Louis

Louis66 — Thu, 20 Oct 2022 10:11:23 GMT

I tried it, but no success either