A slicer can affect more than the chart you clicked. Review its dataset and sheet scope before adding it to a dashboard with several summaries.
Choose the source and column
On a computer, select the relevant chart or pivot table and choose Data > Add a slicer. In the side panel, inspect the data range and select the column to filter.
Google states that slicers apply to charts and pivot tables on the same sheet that use the same dataset. Ordinary formulas using that dataset are not automatically filtered by the slicer.
Review combined slicers and defaults
Use additional slicers for additional filter columns, keeping their source ranges consistent when they represent the same dataset. A mismatch can make dashboard components disagree about the selected population.
A user’s filter selections are private and unsaved unless set as default. Setting current filters as default makes that initial selection apply for people accessing the spreadsheet, so use it deliberately.
Test every affected component
Choose a known category and compare each chart, pivot, and formula-based indicator. Label components that intentionally remain full-population measures so users do not assume all numbers share the slicer’s scope.
Viewers can interact with existing slicers, while adding or removing them requires editing access. A slicer is a viewing tool, not an access-control boundary for sensitive records. Verify the default state after reopening and record the selected conditions for reproducible reports. If unrelated components should not share filtering, redesign their dataset or sheet arrangement explicitly rather than relying on where the slicer happens to sit visually.
References
Reviewed against the linked official product guidance on November 3, 2026. Features, limits, screen labels, and access can vary by account, platform, region, and organization policy.