Waterfall chart with slicer

[talhasaleem15]

Hi, 

I have been trying to creat a waterfall chart where I can adjust the middle bars using a slicer to show the final bar adjusted.

Referring to the picture, I would like to adjust my slicers for margin, protection mix and volume to see changes in the graph separately. For example if I am only changing margin, the rest of the 2 should remain same but the Total bar must change accordingly.

Please let me know if it is possible to do. Thank you!

[v-jingzhang]

Hi @talhasaleem15 

It may be possible, but without data we cannot test that. Can you share some sample data as well as the measures used in the waterfall chart? How do you adjust your slicers for margin, protection mix and volume? Which columns will be put into the slicers?

You could try adding ALLEXCEPT function to your measures to remove all filters except the specified column which is in the corresponding slicer to affect the measure. 

Best Regards,
Community Support Team _ Jing

[PaulDBrown]

Please share sample  data (not an image please) or PBIX file without confidential information and a depiction (Excel helps) of the expected outcome. Thanks!