Power Pivot Slicers: How to Add and Connect Them

A Power Pivot slicer is a clickable filter for a PivotTable built from Excel’s Data Model. In Excel for Microsoft 365 on Windows, select the PivotTable, choose PivotTable Analyze > Insert Slicer, select a field, and click OK; then use the slicer’s buttons to filter the report.

What a Power Pivot slicer is

A slicer is a visual control that lets someone filter a PivotTable by choosing visible buttons, such as a product, region, or year. It performs a filtering job much like a PivotTable field filter, but its choices remain visible beside the report and are easier to operate. A slicer can show which selections are active, and a reader can usually clear them without opening a menu.

“Power Pivot slicer” does not mean a separate kind of slicer. It usually means an Excel slicer attached to a PivotTable that uses the Data Model—the in-workbook analytical model managed by Power Pivot. The model can contain tables linked by relationships, rather than only one flat source table. A slicer filters the PivotTable through the model’s fields and relationships.

For example, a sales model might include a Sales table, a Products table, and a Calendar table. A slicer based on the Products table’s Category field can filter sales totals for categories such as Furniture or Technology, while a Calendar field can filter the same report by year. The slicer is a report control; it does not change or delete the underlying records.

What you need before adding one

Start with a PivotTable created from the Data Model. A normal PivotTable can also have slicers, but it is not necessarily a Power Pivot report. To check the source, select the PivotTable and look at its field list or PivotTable options; model-based reports expose fields from the workbook’s model, which may include several related tables.

If you are building the model from a worksheet table, select a cell in the table and use Power Pivot > Add to Data Model when that command is available. For an external source, use Data > Get Data, then in the load options choose to add the data to the Data Model. Create a PivotTable from the model using the relevant command in the Power Pivot or Insert workflow. The exact import choices depend on the source and Excel build.

Power Pivot is a Windows desktop feature, and its availability depends on the Excel edition and license. If the Power Pivot tab is missing, check File > Options > Add-ins. At the bottom, choose COM Add-ins in the Manage box and click Go; if Microsoft Power Pivot for Excel is listed, enable it. If it is not listed, your installed edition may not provide the add-in. Excel for Mac does not provide the Power Pivot window for building and managing these models. Mac and web support for using or editing workbook features can differ, so use desktop Excel for Windows for the full model workflow.

How to add a slicer

Click inside the Data Model PivotTable you want to filter.
On the ribbon, select PivotTable Analyze > Insert Slicer. If the PivotTable Analyze tab is not visible, first make sure the active cell is inside the PivotTable.
In the Insert Slicers dialog, tick one or more fields, such as Region, Product Category, or Year, and select OK. Choose descriptive fields that make sense as filter choices; measures such as Total Sales are values to summarize, not the usual basis for a slicer.
Move and resize the slicer so it sits near the report it controls. Click a button in the slicer to apply that selection. Use its clear-filter icon to remove the slicer’s current selection and return to all available items.

You can add more than one slicer to the same PivotTable. For instance, a Region slicer and a Year slicer can narrow a report to West in 2025. The PivotTable then reflects both filters at once, provided the selected values exist in the model and the relationships allow those fields to filter the sales data.

Connecting one slicer to multiple reports

A slicer can control more than one PivotTable when those reports are compatible with the same underlying source or Data Model. Select the slicer, open the Slicer tab on the ribbon, and choose Report Connections (called PivotTable Connections in some Excel versions). Tick the PivotTables that should respond, then confirm. Selecting a region in the slicer should now update each connected report.

If a report is absent from the connections list, the PivotTables may not share a compatible PivotTable cache or model. Two reports that look alike are not automatically compatible: one might use the Data Model while another was created directly from a worksheet range. For dependable shared filtering, create the relevant PivotTables from the same Data Model and verify their source before adding the slicer.

This connection is useful for a dashboard with a chart, a sales summary, and a product table. One Year slicer can coordinate all three views, so a reader does not have to change each report’s filter separately. A PivotChart linked to a connected PivotTable can also respond to its filters. Test each connection after setup, especially when the workbook has several reports or fields with similar names.

How selections affect the model

A slicer selection filters the field it represents, and the PivotTable recalculates its displayed summary under that filter context. In a related Data Model, the filter can affect another table through a defined relationship. For example, selecting a product category in a Products table can affect a total calculated from the Sales table when the model has an appropriate relationship between the tables.

A slicer does not create a relationship, repair a broken relationship, or rewrite a DAX measure. If a selection appears to have no effect, the problem may be in the model’s relationships, the field chosen, or the measure’s logic—not in the slicer’s appearance. Likewise, a blank or unexpected total can arise because there are no matching rows for the current combination of filters.

Multiple buttons can be selected in a slicer. Depending on the slicer controls and Excel version, use the slicer’s multi-select control or the available selection behavior to choose several items. For example, selecting two regions shows their combined result, not necessarily separate totals for each region; use Region as a row field as well if you want to compare the regions individually.

Choosing useful fields and designing the control

A slicer is most helpful when its choices are relatively few, meaningful, and likely to be used. Region, department, product group, and year are common choices. A slicer with hundreds or thousands of customer names can take up too much space and make selection cumbersome; a report filter, search-enabled field list, or a more focused hierarchy may be better.

Prefer clear labels. Rename cryptic source columns in the model or source data where appropriate, so the slicer title and buttons are understandable.
Use date fields thoughtfully. A Year or Month field can work well as a slicer. For date-range filtering, consider a Timeline when the PivotTable supports it; a Timeline is a separate date-filter control, not a standard text slicer.
Make the active state obvious. Choose a readable style and enough columns to avoid an excessively tall list. Slicer formatting options are available when the slicer is selected on the Slicer tab.
Explain the scope. Label a dashboard or nearby heading so readers know which reports a slicer affects. A control that updates only one of several nearby charts can otherwise be misleading.

For a compact dashboard, a useful pattern is one or two broad slicers across the top, a summary PivotTable beneath them, and charts or detail reports connected to the same choices. Do not add a slicer for every field simply because Excel offers it; each control adds visual clutter and creates another possible filter combination to understand.

Common problems and fixes

The Insert Slicer command is unavailable. Click inside a PivotTable first. If the report is a regular worksheet table rather than a PivotTable, create a PivotTable before adding a PivotTable slicer.
The slicer does not control a second PivotTable. Select the slicer and inspect Slicer > Report Connections. If the other report is not listed, check whether it was created from the same Data Model or compatible source.
A selection does not change the numbers. Confirm that the selected field belongs to the model, that the relevant tables are related, and that the PivotTable or measure uses those tables. Refresh the PivotTable after updating source data or model relationships.
Items are missing or appear as blanks. Review the source values, relationship keys, and PivotTable options for displaying items with no data. A slicer can only offer values available to its field in the model; unmatched keys can also affect how related records filter.
The report seems stuck on a filter. Check every slicer and PivotTable filter, since more than one filter can be active at once. Use the slicer’s clear-filter icon, and inspect the PivotTable’s field filters if the view still looks restricted.
The slicer shows old choices after data changes. Refresh the model or PivotTable after loading new data. Depending on the source and workbook setup, refresh the query or connection as well as the report.

Refreshing is not the same as clearing a slicer. Refresh updates the report from its source; clearing removes a selection. If a workbook is shared, test refresh and filter behavior in the intended environment and ensure recipients have access to any external data source required for refresh.

Power Pivot slicers compared with other filters

A slicer is an alternative to a PivotTable’s drop-down report filter, not a replacement for every filtering tool. A drop-down filter uses less worksheet space and can suit a field that is changed infrequently. A slicer is more visible and makes the current selection easier to inspect. Both filter a PivotTable, but slicers are particularly practical on dashboards and can be connected to multiple compatible reports.

Excel’s ordinary worksheet filters apply to lists and tables, while a PivotTable slicer controls a PivotTable. A Timeline is designed for date-based filtering and offers a time scale that a regular category slicer does not. In Power BI, slicers are also visual report filters, but Power BI has its own authoring and interaction model; Excel instructions and ribbon paths do not transfer directly.

Frequently Asked Questions

Can I add a slicer to a Power Pivot table?
Yes. Select a PivotTable built from the Data Model, choose PivotTable Analyze > Insert Slicer, select a model field, and confirm. The slicer filters the PivotTable; it is not added directly to the Power Pivot data grid.

Can one slicer control multiple PivotTables?
Yes, if the PivotTables are compatible and share the same source or Data Model. Select the slicer, open Slicer > Report Connections, and select the reports to control. Reports with incompatible sources will not be available to connect.

Why is my Power Pivot slicer not filtering a measure?
A measure returns a calculation, while a slicer filters a field. Check that the slicer uses the correct dimension field and that the model relationships and measure logic allow that field’s filter to reach the data used in the calculation.

Can I use a slicer for dates?
Yes, if the model has a suitable date field, such as Year or Month, you can insert it as a slicer. For selecting date ranges on a timeline, use PivotTable Analyze > Insert Timeline when that command is available for the PivotTable.

Do Power Pivot slicers work in Excel for Mac?
Excel for Mac does not include the Power Pivot window for building and managing Data Models. Slicer support for PivotTables can vary by platform and version, so use Excel for Microsoft 365 on Windows to create and manage the full Power Pivot workflow described here.

Try it: the Percentage Formula Generator: percent of, percent change, increase and decrease, with the formula.

More in Charts & pivot tables

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.