Slicers in Power View

Slicers are a kind of filter. Place a slicer on a sheet to filter all of the visualizations on the sheet at once. When you click an item in the slicer, all of the visualizations with related content are filtered by the item you select. Power View slicers act much like slicers in Power Pivot in Excel.

You can add more than one slicer to your report, and the filtering effects of all slicers are combined. Slicers filter each other.

1. Create a single-column table from any field that is an attribute, such as Name or Category, and not a numeric value.
   
   You can use images in your data as slicers. Read more about using images in Power View.

2. On the Design tab > Slicer.

   The table is converted to a slicer.

3. Click a value in the slicer to filter the contents of the sheet or view. To select multiple values, hold the Ctrl key when you click.

4. To clear the slicer filter, hover over the slicer, and then click Clear Filter in the upper-right corner of the slicer.

In this image, the Discipline Image slicer on the left is filtering for figure skating, so only figure skating data appear in the matrix and in the column chart on the right.

Filtering with a slicer is different from other types of filters. Slicers:

• Filter charts. They do not highlight charts.

• Are saved with the workbook or report. When you save, close, and reopen a workbook or report, the same values will be selected in the slicer.

• Can use image fields. Behind the scenes, Power View uses the Row Identifier field for that image in the data model as the filter in the slicer. If the data model is in Excel, you may need to Configure table behavior properties for Power View reports.

Top of Page