• 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

    Hui...

  • 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)

C

Christof

Member
Hi,

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.

Thanks
Chris
 
Hi, restart from here :​

Site Rules - New Users - Please Read

Hi all, Welcome to the Chandoo.org Forums. Posting Rules & Etiquette The Chandoo.org Forums is a collaborative and happy place to learn and expand your Excel knowledge. The Chandoo.org Forums consist of several Sub-Forums based on the type of question/area of Excel you are interested in...
chandoo.org
 
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.
 
You must log in or register to reply here.
Back
Top