topic Re: Remove blanks from simple waterfall chart in Custom Visuals Development Discussion

Remove blanks from simple waterfall chart

Anonymous — Wed, 10 Sep 2025 14:30:59 GMT

I need help in constructing a waterfall chart removing bars that are blank.

So here are my visuals:

I tried to add a filter to show bars only if the value is not blank. But the drop down menu is anavailable.
How can I adjust my graph?

Re: Remove blanks from simple waterfall chart

lbendlin — Sat, 13 Sep 2025 13:47:25 GMT

Please provide sample data that covers your issue or question completely, in a usable format (not as a screenshot).
Do not include sensitive information. Do not include anything that is unrelated to the issue or question.
Please show the expected outcome based on the sample data you provided.

Need help uploading data? https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-Forum/ba-p/963216
Want faster answers? https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

Re: Remove blanks from simple waterfall chart

grazitti_sapna — Mon, 29 Sep 2025 18:37:34 GMT

Hi Anonymous ,

Please follow these steps:

Select the Waterfall chart.
Drag Category to the Category field.
Drag Amount to the Y-axis / Values field.(Change Aggregation from Count → Sum.)
At this point, you’ll see blank bars for Discounts and Ending Balance.
In the Filters pane, drag the Amount field to Filters on this visual.
Choose Filter type: Advanced filtering → is not blank.
Apply the filter → blank bars disappear.

🌟 I hope this solution helps you unlock your Power BI potential! If you found it helpful, click 'Mark as Solution' to guide others toward the answers they need.

💡 Love the effort? Drop the kudos! Your appreciation fuels community spirit and innovation.

🎖 As a proud SuperUser and Microsoft Partner, we’re here to empower your data journey and the Power BI Community at large.

🔗 Curious to explore more? [Discover here].

Let’s keep building smarter solutions together!