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 other values are ok in the visual, only the (Zero) is showing wrong.

 

The issue happens in the Power BI Desktop and service.

 

Any Idea how to solve it?

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.

4 Replies

  • 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

  • Ashish_Mathur's avatar
    Ashish_Mathur
    Icon for Super User rankSuper User
    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
    Icon for Community Support rankCommunity Support
    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.

  • RdgBrito's avatar
    RdgBrito
    Frequent Visitor
    5 years ago

    Thanks all for the help, in fact I used 2 solutions combined to solve the issue. I'm using the Decimal type - because is a measure and I can't found how to change the data type - solution by v-yingjl and also the ROUND function from Ashish_Mathur.

     

    Thanks guys, my visual is good now.