What are Slicers in Pivot Table?

Data Science, AI and ML
,
1

Slicers provide buttons that you can click to filter tables or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is currently displayed.

You can use a slicer to filter data in a table or Pivot Table with ease.

Create a Slicer to Filter Data:

  1. Click anywhere in the table or Pivot Table.
  2. On the Home tab, go to Insert > Slicer.
  3. In the Insert Slicers dialog box, select the checkboxes for the fields you want to display, then select OK.
  4. A slicer will be created for every field that you select. Clicking any slicer buttons will automatically apply that filter to the linked table or PivotTable.
  5. You can adjust your slicer preferences in the Slicer tab (in newer versions of Excel), or the Design tab (Excel 2016 and older versions) on the ribbon.
  6. Note: Select and hold the corner of a slicer to adjust and resize it.
  7. If you want to connect a slicer to more than one PivotTable, go to Slicer > Report Connections > check the PivotTables to include, then select OK.
  8. Note: Slicers can only be connected to PivotTables that share the same data source.
  9. Notes:
  • To select more than one item, hold Ctrl, and then select the items that you want to show.
  • To clear a slicer’s filters, select Clear Filter in the slicer.