Stockertim Dictionary · Technology · Business
Slicer
Also called slicers, pivot slicer, filter buttons
In short
A panel of on-screen buttons linked to a pivot table or table that filters the data with a click and shows at a glance which filter is applied.
- Intermediate
- Technology
- Checked
In detail
A slicer is a visual filter. Inserted for a field such as Region, it shows one button per region; clicking North limits the connected pivot table to northern records, and the selected button stays highlighted so readers can see what they are looking at. Several items can be chosen together, and a clear button removes the filter. A timeline is a related control for date fields, filtering by days, months, quarters or years along a bar.
One slicer can control more than one pivot table at once, through its report connections, provided the pivots are built on the same source data. This is how simple dashboards are made: a handful of pivots and charts on one sheet, all driven by two or three slicers for region, product and period. Slicers can also be attached to formatted tables, filtering the rows directly.
Compared with the drop-down filters in the pivot itself, slicers are easier for occasional users and more honest about the current view, since the active filter is on display. They also show items with no data in a fainter style, which helps readers notice gaps.
The risks come from forgetting that a filter is on. A dashboard saved with one region selected opens that way for the next reader, and figures copied from it describe only that region. Slicers on pivots that do not share a source cannot be connected, and slicers on very large models can slow the workbook.
Worked example
A dairy cooperative in Eldoret builds a dashboard with three pivot charts and one Region slicer connected to all of them.
- With no selection, total milk collected shows 50,000 litres
- Clicking Rift and Western shows their combined share: 18,000 + 12,000 = 30,000 litres
All three charts switch to the two regions together, and the highlighted buttons show the filter.
In practice
Managers use slicers on monthly dashboards to switch between regions, products and periods during meetings without editing anything, and report builders connect them to every relevant pivot.
Watch out
- Clear slicers before saving or sharing, or note the active filter on the sheet.
- A slicer cannot be connected to pivots built from different sources.
Learn it properly
Official sources
- Data visualisation: charts · Government Analysis Function
Facts last checked on 9 November 2026.
Education, not advice: the Stockertim Dictionary explains what terms mean. It never recommends buying or selling anything.