The Power of Slicers

The Power of Slicers

Slicers provide buttons that you can click to filter table data, or PivotTable data. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is shown in a filtered PivotTable.Excel Ribbon ImageWhen you select an item, that item is included in the filter and the data for that item will be displayed in the report. For example, when you select Callahan in the Salespersons field, only data that includes Callahan in that field are displayed.

Create a slicer in an existing PivotTable

  1. Click anywhere in the PivotTable for which you want to create a slicer.
  2. On the Analyze tab, click Insert Slicer. In older versions of Excel, click the Options tab, and then click Insert Slicer.
  3. In the Insert Slicers dialog box, select the check box of the PivotTable fields for which you want to create a slicer.
  4. Click OK.

    A slicer is displayed for every field that you selected.

  5. In each slicer, click the items on which you want to filter.To select more than one item, hold down CTRL, and then click the items on which you want to filter

Create a slicer in an existing table

Please note that this feature is supported using Excel 2013 and later.

  1. Click anywhere in a table for which you want to create a slicer.
  2. On the Insert tab, click Slicer.
  3. In the Insert Slicers dialog box, select the check box of the fields (columns) for which you want to create a slicer.
  4. Click OK.A slicer is displayed for every field (column) that you selected.
  5. In each slicer, click the items on which you want to filter.To select more than one item, hold down CTRL, and then click the items on which you want to filter.

Format a slicer

  1. Click the slicer that you want to format.
  2. On the Options tab, in the Slicer Styles group, click the style that you want

Make a slicer available for use in another PivotTable

If you have a slicer on a PivotTable already, you can use that same slicer to filter another PivotTable. Please note that this only works when the two PivotTables use the same data source.

  1. First create a PivotTable that is based on the same data source as the PivotTable that already has the slicer you want to reuse.
  2. Click the slicer that you want to share in another PivotTable.This displays the Slicer Tools, adding an Options tab.
  3. On the Options tab, in the Slicer group, click Report Connections. Please note that in older versions of Excel this button may be called PivotTable Connections.
  4. In the dialog box, select the check box of the PivotTables in which you want the slicer to be available

Disconnect a slicer

  1. Click anywhere in the PivotTable for which you want to disconnect a slicer.This displays the PivotTable Tools tab.
  2. In Excel 2016, click the Analyze tab, and then click Filter Connections. In older versions of Excel click the Options tab > Insert Slicer > Slicer Connections.
  3. In the dialog box, clear the check box of any PivotTable fields for which you want to disconnect a slicer.

Delete a slicer

Do one of the following:

  • Click the slicer, and then press DELETE.
  • Right-click the slicer, and then click Remove <Name of slicer>.

Slicer components

A slicer typically displays the following components:

PivotTable slicer elements 1. A slicer header indicates the category of the items in the slicer.

2. A filtering button that is not selected indicates that the item is not included in the filter.

3. A filtering button that is selected indicates that the item is included in the filter.

4. A Clear Filter button removes the filter by selecting all items in the slicer.

5. A scroll bar enables scrolling when there are more items than are currently visible in the slicer.

6. Border moving and resizing controls allow you to change the size and location of the slicer.

Source of article can be found here

    • Related Articles

    • Setting up an Excel ODBC (32bit) System DSN

      Issue You would like to connect to Excel files to use as data in your Intelligence Reports Resolution You need to configure a 32bit System DSN on all workstations. Instructions as follows: Set up a System Data Source Name (DSN) using the Microsoft ...
    • Reducing the size of Microsoft Excel file automatically

      Here is a quick tip on reducing the size of Microsoft Excel file quickly and easily. You may need to reduce it for any number of reasons, and this is a quick way to get that done. Launch Microsoft Excel or the Microsoft Workbook in question Go to ...
    • Create a PivotTable to analyze worksheet data

      Being able to quickly analyze data can help you make better business decisions. But sometimes it’s hard to know where to start, especially when you have a lot of data. PivotTables are a great way to summarize, analyze, explore, and present your data, ...
    • Unable to set the Interactive Property of the Application Class

      Issue When running a report, you are running into an error about setting the Interactive Property for the Application Class. Symptoms When running a Report out the following error is received: Unable to set the Interactive property of the Application ...
    • BI Generator / BI Tools missing in excel in a Terminal Server environment

      Products Sage 100 ERP Sage 300 ERP Sage ERP X3 Sage Intelligence Sage 500 ERP Description The BI Generator / BI Tools missing in excel in a Terminal Server environment. Even though it is licensed and installed. Not showing in both the Ribbon on excel ...