Forum Discussion
Endpoints changing on Waterfall Chart
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!
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
1 Reply
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