Forum Discussion

powerjey's avatar
powerjey
Helper I
3 years ago

How to remove zero values from Power BI Waterfall visual?

Hi everyone,

 

Hoping someone can help me on this. 

 

Two questions: 

1. Is it possible to remove any zero values in the Power BI Waterfall visual? 

The categories are a month-over-month comparison of a product BOM costs with has 300+ components.

 

The issue is that I would like to hide any values that do not change month to month (delta of 0). 

 

2. Is it possible to eliminate horizontal scrolling by getting the visual to fit to the page? 

 

 

 

1 Reply

  • v-yinliw-msft's avatar
    v-yinliw-msft
    Community Support

    Hi powerjey ,

     

    For the first question, I think you can do this:

     

    For the second question, as far as I know, I'm afraid that we may not achieve your requirement in Power BI currently.

    Only the manually change the size of visual like this:

     

    Hope this helps you.

    Here is my PBIX file.

     

    Best Regards,

    Community Support Team _Yinliw

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.