Multi-Select Slicer Items in Microsoft Excel Pivot Tables

If you are wondering what is slicer; it helps to add a level of interactivity in our reports. Even you can use the multi-select slicer items too. You only have to click on your slicer and then it will be enabled.

NOTE : You can create random excel workbook online here for practice purposes as I did in this tutorial.

Browse Our Catalogue: Excel FormulasExcel MacrosPower BI

Following are the steps to follow:

STEP1. To insert a new pivot table follow this: click on your data firstly then

Insert > Pivot Table > New Worksheet or Existing Worksheet

Multi-Select Slicer Items

STEP2. Put in the Name field in your ROWS section while in the VALUES section put in the Cash field.

Multi-Select Slicer Items

STEP3. Now add the slicer by following: 

Go to PivotTable Analyze > Filter > Insert Slicer

Multi-Select Slicer Items

STEP4. Click OK but make sure you have selected GENDER Option.

Multi-Select Slicer Items

Now you are having your slicer, so you just need to tick only the Multi-Select button to enable this.

Multi-Select Slicer Items
Therefore, we can differentiate using a splicer