You can insert new Slicer to the PivotTable based Dashboards. Please follow the below instruction to insert new Slicer:

 

  1. Select the PivotTable to insert New Slicer
  2. Go to PivotTable Analyze Tab in the Excl Ribbon Menu and Click on Insert Slicer Command from Filter Group
  3. Choose the Required Field/Dimension from the Insert Slicer Dialog
  4. Now, You can see the new Slicer on Your Worksheet, You can place it at the required place in the Worksheet.

Example:

Dashboard in  ‘PMD02 Project Management Dashboard – Multiple Projects’ Templates is created based on the PivotTable in the ‘Dashboard’ Sheet. You can add new Slicer to filter the dashboard based on a new Dimension.

Inserting New Slicer