Synchronising slicers across report pages

This nifty feature actually performs two separate functions: it allows you to repeat a slicer on different report pages, and it lets a slicer filter different pages.

Getting slicers to appear on multiple pages

Firstly, you can get a slicer to appear on every page:

You can select the slicer on the left, and get it to appear on any other pages of your choice.

Of course, you need to have left room for it!

On this page we should have moved the chart to one side, to make room for the perma-slicer.

Synchronising slicers across pages

Secondly, you can get the choices you make in a slicer to apply to other pages in your report:

This is page one of your report, and we've chosen to view data for the West Midlands region.

The slicer choice applies also to the second report page:

This is page two, and it's only showing sales for towns in the West Midlands region, even though the page doesn't contain any filters or slicers.

How to create synchronised slicers

Having seen what they do, here's how to create synchronised slicers.  First, choose to display the relevant pane:

In the View tab of the ribbon, tick the Sync slicers box.

Next, select the slicer whose settings you want to change:

Here we're going to change the sync settings for the region name slicer.

Choose how you want this slicer to work on other pages:

This slicer (on page 1) will also be visible on page 3 (that's what the right-hand column means). Any choice that you make within the slicer will also apply to page 2 (that's what the left-hand column means).

In practice you would probably tick either both columns or neither column for any given page: having an invisible slicer which controls what you see (or a visible one which doesn't) is likely to confuse everyone!