Forum Discussion

darrentlwong's avatar
darrentlwong
New Member
7 years ago

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

 

 

1 Reply

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    7 years ago

    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.

     

    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.

     

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

     

    Best Regards

    Maggie