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.

Power View Refresh

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.

 Tip    You can use images in your data as slicers. Read more about using images in Power View.

  1. On the Design tab > Slicer.

The table is converted to a slicer.

  1. Click a value in the slicer to filter the contents of the sheet or view.

 Tip    Select multiple values by holding the Ctrl key when you click.

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

 Tip   . Select all except a certain set of values by resetting the filter with the button in the upper-right corner, and then using Ctrl + click to unselect specific values. This shows overall values excluding the unselected values

 Note    Clicking values in a table that is not a slicer does not filter the report.

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.

Slicer with images filters other visualizations in Power View

The slicer on the left filters the values in the matrix and 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.

Read about Filtering and highlighting in Power View.

Top of Page Top of Page

See Also

Filtering and highlighting in Power View

Power View: Explore, visualize, and present your data

Power View and Power Pivot videos

Tutorial: PivotTable data analysis using a Data Model in Excel 2013

Top of Page Top of Page

 
 
Applies to:
Power View in Excel 2013, Power View in SharePoint Server 2013, SharePoint Server 2013 Enterprise