Forum Discussion

Louis66's avatar
Louis66
Resolver I
3 years ago
Solved

Problem with SWITCH to change colors

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 i...
  • v-jianboli-msft's avatar
    v-jianboli-msft
    3 years ago

    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's avatar
Jayee
Responsive Resident
3 years ago

Hi Louis66 ,

 

try below DAX Measure

colour =
SWITCH (
SELECTEDVALUE ( 'Cookie Types'[Cookie Type] ),
"Sugar", "Red",
"Orange"
)
  • lukiz84's avatar
    lukiz84
    Memorable Member
    3 years ago

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

  • Louis66's avatar
    Louis66
    Resolver I
    3 years ago

    Hello,

     

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

     

    Louis