Forum Discussion

talhasaleem15's avatar
talhasaleem15
Regular Visitor
4 years ago

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.

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!

 

Need Help

2 Replies

  • PaulDBrown's avatar
    PaulDBrown
    Icon for Community Champion rankCommunity Champion
    4 years ago

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

  • v-jingzhang's avatar
    v-jingzhang
    Icon for Community Support rankCommunity Support
    4 years ago

    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