Link slicer to multiple columns in table

[teggl97]

Hi everyone

Sorry if this is a duplicate, I couldn't see anything similar that had already been posted.

Is it possible to have one slicer link across multiple columns? I have 4 columns with the same drop-down options, and would like one slicer that can filter on all 4 columns, rather than 4 slicers.

Here is an example:

Any help would be greatly appreciated

 

[johnny51981]

That isn't how the Slicer works. Think about them as a floating version of each column's Auto Filter.

The only One to Many option for Slicers is using 1 Slicer for multiple PivotTables sourced from the same data