Waterfall chart shows wrong values for 0.

[RdgBrito]

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?

[Ashish_Mathur · Accepted solution]

Hi,

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

[RdgBrito]

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.

[v-yingjl · Accepted solution]

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.

[Ashish_Mathur · Accepted solution]

Hi,

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

[OwenAuger]

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