Connecting slicers on powerpivots

[aeroguy1]

Hi,

Is there a way to connect slicers on PowerPivots?

I'm very new to this and have been handed a complex workbook. Trying to get all the slicers to function as one. I have worksheets that show pivots of data across multiple data tables that the slicers work for, and another group that pivots data from just one sole data table that the slicers function together. How can I get so all slicers work together?


Thank you so much.

 

[scottsen]

Is the gist of your question "can 1 slicer control multiple (power) pivot tables" ? If so, then "yes". What excel version?

 

[aeroguy1]

Yes that is my question. Excel 2013.

Thanks.

 

[TimRodman]

Just right-click on the slicer and choose Report Connections... like this. Then you can pick which pivot tables to apply it to.