Forum Discussion

djbuncle's avatar
djbuncle
Helper I
7 years ago
Solved

Waterfall error with value containing switch

Hi. I'm having trouble with a waterfall chart output whereby the value for each category returns 0 (seen in red in the screenshot). The value slices correctly with the elements when in a table or ma...
Need Help
  • djbuncle's avatar
    djbuncle
    7 years ago

    Hi mwegener. I actually solved this, the issue was that within my SWITCH statement I had different formatting for the various metrics I was using. Some #,0 and others #,0.0. This was enough to upset the waterfall visual. After removing the formatting it worked fine.

mwegener's avatar
mwegener
Most Valuable Professional
7 years ago

Hi,

can you provide the PBIX file?

djbuncle's avatar
djbuncle
Helper I
7 years ago

Hi mwegener. I actually solved this, the issue was that within my SWITCH statement I had different formatting for the various metrics I was using. Some #,0 and others #,0.0. This was enough to upset the waterfall visual. After removing the formatting it worked fine.

  • mwegener's avatar
    mwegener
    Most Valuable Professional
    7 years ago

    good to know