Forum Discussion

RdgBrito's avatar
RdgBrito
Frequent Visitor
5 years ago
Solved

Waterfall chart shows wrong values for 0.

In the waterfall chart visual, my 0 number it's showing weird in the visual, but when we look for the values in the "show as table" the value in the table are correct as you can see below: All...
Need Help
  • Ashish_Mathur's avatar
    Ashish_Mathur
    5 years ago

    Hi,

    You may want to use the ROUND() function to get that small number to become a perfect 0.

  • v-yingjl's avatar
    v-yingjl
    5 years ago

    Hi RdgBrito ,

    Seems like your data type is decimal number, you can change it to fixed decimal number type to check:

     

    Best Regards,
    Community Support Team _ Yingjie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

OwenAuger's avatar
OwenAuger
Icon for Super User rankSuper User
5 years ago

Hi RdgBrito 

It looks like you may have to provide a custom number format for [AR Change Full Dynamic] to eliminate the E notation.

These steps worked in a test pbix at my end:

  1. Change the number format for [AR Change Full Dynamic] to #0,,.0M
    (either on Column Tools or Measure Tools (as appropriate) on the ribbon, or on the Model View > Properties)
  2. On the Waterfall visual, Format Pane > Data Labels:
    Display units = None
    Value decimal places = Auto

Regards,

Owen