Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
11 months 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 down menu is anavailable.
How can I adjust my graph?

 

2 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    11 months ago

    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

  • grazitti_sapna's avatar
    grazitti_sapna
    Super User
    10 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!