Forum Discussion

Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
4 years ago

DAX help: switch selectedvalue not working

Hi everyone, I have a switch DAX. However when I add it to the visual, it shows "Can't display the visual":    Tickets_WOW_% = SWITCH(SELECTEDVALUE(Tickets_Measures[Name]), "Revenue", IF(AND(Tick...
Winniethewinner's avatar
Winniethewinner
Icon for Helper IV rankHelper IV
4 years ago

Thanks for the reply. I've changed the formula as you and tamerj1 suggested, however the WOW_% shows the $ instead %. 

A bit more background, I used calculation group to switch the measures and its respective number format, where Rev shows $ format and count shows as decimal number format. 

If I add FORMAT to Tickets_WOW_% formula and create a chart showing WOW% by dimension, the chart will not display. Any idea how to fix it? Thanks. 

tamerj1's avatar
tamerj1
Icon for Community Champion rankCommunity Champion
4 years ago

Winniethewinner 

Adding FORMAT will change it into a string. You need to chsnge the format manually to %

  • Winniethewinner's avatar
    Winniethewinner
    Icon for Helper IV rankHelper IV
    4 years ago

    It doesn't work ☹️, and still shows as $.