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

MattAllington's avatar
MattAllington
Icon for Community Champion rankCommunity Champion
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

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

    Thanks Matt! That's a pitty.