• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VBA to iterate through Slicer Items (Power Pivot)



I have developed a dashboard that links my entire data model using Power Pivot and gives a nice range of tables as an output.

My question is, is it possible to create a macro button that will select each item in the slicer, and then print it.
I have done this in the past using a dropdown menu, but was wondering if it's possible to do with a slicer box?

Any help would be greatfully appreciated.


Marc L

Excel Ninja
Hi, restart from here :​

GraH - Guido

Well-Known Member
After reading the previous, you can continue here: Using SELECTEDVALUES To Capture Power BI Slicer Selections. It contains a link that explains how to list even multiple selections from a slicer. Then making the macro your after would be easy for you I assume since you did it before via drop down selections.