Enable workbook slicers in reports.

The workbook slicer pane can be turned on in Excel using the Slicer > Workbook Slicers ribbon item.

On the web, a toolbar button to toggle the pane is enabled if the current report has workbook slicers available.