How to use a slicer with multiple pivot tables

This makes slicers very useful for building dashboards that are based on pivot tables.

In this worksheet, we have a simple pivot table that shows total sales by Product.

Next, I’ll add a slicer to filter by Region.

Notice that, at this point, the slicer controls only one pivot table.

All slicers have a setting that links them to pivot tables, called “Pivot Table Connections”.

you’re able to access this setting using the button on the Slicer Tools tab of theribbon.

Or, you’ve got the option to right-click and select from the context menu.

The pivot table currently controlled by the slicer will be checked.

Remember that you’re able to name your pivot tables to be more descriptive.

In the case of slicers, this can make it easier to set and confirm Pivot Table Connections.