Forum Discussion

dgilm33's avatar
dgilm33
Icon for Helper I rankHelper I
3 years ago
Solved

Donut Graph disappearing when using FORMAT dax

Hello, I am attempting to use a SWITCH formula to change between a count of something to the sales. This works, however I need the sales to show the "$" sign when switched to it, and the count to be ...
Need Help
  • vicky_'s avatar
    vicky_
    3 years ago

    The reason it doesn't work (probably) is because when you use FORMAT, the type of your measure changes to a text rather than a number (which can't be aggregated in the same way). One way of getting around this is by using the using the dynamic formatting option for your measures. You can take a look at the SQLBI tutorial for doing so here: https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/

vicky_'s avatar
vicky_
Icon for Super User rankSuper User
3 years ago

The reason it doesn't work (probably) is because when you use FORMAT, the type of your measure changes to a text rather than a number (which can't be aggregated in the same way). One way of getting around this is by using the using the dynamic formatting option for your measures. You can take a look at the SQLBI tutorial for doing so here: https://www.sqlbi.com/articles/introducing-dynamic-format-strings-for-dax-measures/