cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
darrentlwong New Member
New Member

Waterfall negative values on Y axis

Hi Power BI community,

 

I am having a little trouble with my waterfall chart. As seen below, the negative values are not below the 0 line on the y axis, this is making the chart look rather strange. 

 

Does anyone know how to format this? 

 

Does anyone also know how to get rid of the "Other" category? I have already expanded my breakdowns to the maximum of 10, which should be sufficient for my chart.

 

Thanks!

 

Darren

 

 

Power BI capture.PNG

1 REPLY 1
Community Support Team
Community Support Team

Re: Waterfall negative values on Y axis

Hi @darrentlwong

As seen below, the negative values are not below the 0 line on the y axis, this is making the chart look rather strange. 

 

By design, the negative values of the breakdown doesn't show below 0 line, it shows the what's contributing  to the changes month to month (negative and positive, in  waterfall chart)

To make the chart look more obviously, you could change the color of negative differenly from positive colors.

1.png

 

Does anyone also know how to get rid of the "Other" category? I have already expanded my breakdowns to the maximum of 10, which should be sufficient for my chart.

 

As tested with my data with 7 distinct category (this column added in the breakdown field), when i set breakdown to 7, it show all categories without "other" item, when i set to 6, it show an "other" item.

3.png

 

Please show me some example of your data added into this visual so i can anlyze better for you.

 

Best Regards

Maggie