Forum Discussion

sguenther's avatar
sguenther
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Combine FORMAT() and SWITCH()

Hey guys,   quick DAX question: I would like to create a really interactive report for my colleagues and one issue I couldn't solve so far was the following. I created a Slicer for "relative" and "...
Need Help
  • MattAllington's avatar
    MattAllington
    10 years ago

    Yes I know - it can't be done if you want to have it as a number.  You can add a format (effectively turning it into text) if you want, but then it wont work on charts etc.  It is an unfortunate limitation that you can't switch formats

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hello,

 

Is there any updates for this question? I have exactly same question. 

 

Thank you,

 

Jarvis