cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
talhasaleem15
Regular Visitor

Waterfall chart with slicer

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.

talhasaleem15_0-1632065944771.png

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!

 

2 REPLIES 2
v-jingzhang
Community Support
Community Support

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
Super User
Super User

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





Did I answer your question? Mark my post as a solution!
In doing so, you are also helping me. Thank you!

Proud to be a Super User!
Paul on Linkedin.






Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.