Filter dashboard charts and pivots with slicers in Google Sheets

Quick answer

Select a dashboard pivot or chart, choose Data > Add a slicer, and select the source column. Slicers affect same-data charts and pivots on that sheet, but not ordinary formulas. Your selection stays private and is not saved unless you make it the default.

Build a controlled dashboard

Use desktop Google Sheets and a private practice workbook you can edit. Creating or removing a slicer requires edit access; people with access can adjust an existing slicer. Do not test shared defaults on a production dashboard.

Enter this range in A1:C5 on a tab named Dashboard:

Region	Product	Revenue
East	Pen	120
West	Pen	80
East	Book	60
West	Book	40

Create a pivot from A1:C5 with Insert > Pivot table, placing it in an empty area of the same sheet, such as E1. Add Product as Rows and SUM of Revenue as Values. Leave sufficient space for the pivot to expand. Expected unfiltered results are Pen 200, Book 100, total 300.

In J1 enter All-source check, and in J2 enter =SUM(C2:C5). This independent 300 is intentionally not part of the pivot. It will demonstrate why a spreadsheet formula should not be mislabeled as a slicer-controlled KPI.

Apply and inspect the slicer

1. Select the pivot, then choose Data > Add a slicer.
2. In the slicer’s settings, verify the source range is Dashboard!A1:C5 and choose Region as the column.
3. Open the slicer filter. Under Filter by values, leave East selected and hide West.
4. Compare the pivot: Pen should now be 120, Book 60, and total 180.
5. Inspect J2. It should remain 300 because the SUM formula still evaluates every source value.

If you already have charts on this same sheet using this same data set, check that they follow the selection too. A chart using a different range, a different source or a separately calculated summary is not a valid test of that claim.

Test a second view without changing defaults

Change the slicer to West only. Expect Pen 80, Book 40 and total 120, while J2 remains 300. Then select both regions again to return the pivot to 300.

Only in this private workbook, choose East again, open the slicer’s More menu and select Set current filters as default. Close and reopen the workbook to check the default. Defaults are shown to everyone with access, so treat this as a shared dashboard change in real files, not a private bookmark. Finish by selecting both regions and making that the default instead.

Reconcile one source edit

With both regions selected, change C2 from 120 to 150. The pivot total and J2 should both become 330. Filter to East: the pivot total becomes 210, while J2 stays 330. Reset C2 to 120 and the slicer to both regions. This isolates data changes from filter changes.

Troubleshooting and scope

If several slicers do not cooperate, compare their source ranges exactly. Add a separate slicer for each different column you need to filter; keep the same range. To change a slicer’s range, column or title, use More > Edit slicer. Delete the slicer object, rather than source rows, to remove the control.

For reusable row views instead of dashboard controls, see filter views. This guide is based on desktop documentation. No live multi-user, saving or slicer test was performed; the figures above are independently calculated expectations.

Official references

• Filter charts and tables with Slicers - Google Docs Editors Help
• Create & use pivot tables - Computer - Google Docs Editors Help