Forum Discussion
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...
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.
Adding FORMAT will change it into a string. You need to chsnge the format manually to %
It doesn't work ☹️, and still shows as $.