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.

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.