Endpoints changing on Waterfall Chart

[kg4u]

Hi All,

I have a waterfall chart which is misbehaving.  I have 4 different companies in a standard slicer.  When I select a different company in the slicer the endpoints on my waterfall are changing.

This is the correct view and the way I would like to see the chart presented when selecting different companies in the slicer.

When I switch the companies in the slicer the endpoints are changing.  Notice how the endpoints are changing, this is the bad behavior. Which I would like to correct.  Does anyone have any ideas?

For reference here are the settings I have on the waterfall chart

and I have two separate tables in my data model, one called Category and one called Breakdown.

I welcome any ideas on what I can do to keep the end points from changing when I select a different company in the slicer.

Thank you!

[Anonymous · Accepted solution]

Hi @kg4u ,

In order to make troubleshooting and give you a suitable solution, could you please provide some sample data refer in waterfall (exclude sensitive data) with Text format and the formula of measure [Total Sales Chg]? By the way, how did you sort the data for the waterall? It is better if you can share a simplified pbix file. You can refer the following link to upload the file to the community. Thank you.

How to upload PBI in Community

Best Regards