Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Remove blanks from simple waterfall chart

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 d...
grazitti_sapna's avatar
grazitti_sapna
Icon for Super User rankSuper User
11 months ago

Hi Anonymous ,

Please follow these steps:

  1. Select the Waterfall chart.
  2. Drag Category to the Category field.
  3. 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.
  4. In the Filters pane, drag the Amount field to Filters on this visual.
  5. Choose Filter type: Advanced filtering → is not blank.
  6. 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!