Problem with SWITCH to change colors

[Louis66]

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

[v-jianboli-msft · Accepted solution]

Hi @Louis66 ,

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.

[Jayee]

Hi @Louis66 ,

try below DAX Measure

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

[Louis66]

Hello,

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

Louis

[lukiz84]

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

[lukiz84]

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

[Louis66]

I tried it, but no success either