3.3Slicers, timelines & simple dashboards
The essentials in 30 seconds
- Slicers are clickable filters: buttons connected to the pivot table — one click filters the pivot table and the associated charts, without touching the formulas.
- The timeline filters by dates: a slider for month/quarter/year — and a slicer can drive several pivot tables via report connections.
- The dashboard separates the roles: Data sheet, Pivot sheet, Dashboard sheet — KPIs at the top, readable visuals, slicers to explore.
Running mini-case — Wassim delivers a dashboard the director uses alone
Wassim, an accountant in Algiers, sends each week a file his director does not dare to filter for fear of «breaking the formulas». He assembles a dashboard: two pivot tables (sales, margins), their charts, a Region slicer and a timeline connected to both. The director clicks «Oran» then «Q3»: everything synchronizes. Wassim no longer redoes the file each week — the director explores alone.
The same case returns in the course, the diagram, the script and the 48h challenge.
1. Slicers and timelines: filters everyone dares to click
A slicer is a visual filter: clickable buttons (the regions, the categories…) connected to a pivot table. One click filters the pivot table and the associated charts. Far more intuitive than the drop-down filter menus, and perfect for a dashboard handled by non-experts like Wassim's director.
The timeline is a slicer specialized for dates: a slider to choose a month, a quarter, a year. And above all, a single slicer or timeline can drive several pivot tables at once (Report Connections) — it is the key to synchronizing a whole dashboard with one click.
2. Assembling a simple, maintainable dashboard
A simple dashboard = a few pivot tables/charts + shared slicers, on a dedicated sheet. Principle: key indicators at the top, readable visuals, slicers to explore. Wassim displays revenue, margin and average basket at the top, then the filterable visuals.
You separate the «Data» sheet, the «Calculations/Pivot» sheet and the «Dashboard» sheet — clear and maintainable. Piling everything on a single messy sheet, and an unconnected slicer desynchronizes the visuals: checking the report connections is part of the recipe.
🔎 Concrete example — One click filters the whole dashboard
Wassim's sales dashboard with a «Region» slicer:
Region slicer (Algiers | Oran | Constantine | Annaba)
=> connected to PT_Sales AND PT_Margin AND the charts
Click on «Oran» => all the visuals show only OranReading: the report connections link a slicer to several pivot tables.
Lesson: the user explores with one click, without touching the formulas.
Section vocabulary
- Slicer
- Visual button filter connected to one or more pivot tables — one click filters everything.
Simple example: Wassim's Region slicer (Algiers, Oran…).
What it is not: a hidden drop-down filter nobody dares to touch.
Reflex: shared table = visible slicers.
- Timeline
- Slicer specialized to filter by dates: month, quarter, year via a slider.
Simple example: The Q3 timeline of Wassim's dashboard.
What it is not: dates typed by hand into a filter.
Reflex: Date field = timeline, always.
- Report connections
- Link a slicer to several pivot tables to synchronize everything with one click.
Simple example: A Region slicer that drives sales AND margins.
What it is not: visuals each filtered on their own side.
Reflex: each slicer checked: which pivot tables does it drive?
- Dashboard
- Summary view: key indicators + visuals + slicers, on a dedicated sheet.
Simple example: The director's weekly steering sheet.
What it is not: a workbook where everything is piled on one sheet.
Reflex: KPIs at the top, visuals below.
- Separate sheets
- Data / Pivot / Dashboard: three roles, three sheets, a maintainable file.
Simple example: Wassim no longer touches the formulas each week.
What it is not: data and visuals mixed on one sheet.
Reflex: never a visual on the data sheet.
In practice — Making a pivot table interactive
- On a pivot table, insert a slicer (PivotTable Analyze ▸ Insert Slicer).
- Add a timeline on the Date field.
- Create a 2nd pivot table and connect the same slicer to both (Report Connections).
- Gather visuals and slicers on a «Dashboard» sheet.
Ready-to-say script — delivering the dashboard (30 s)
«Here is your weekly steering: at the top the three key figures, below the visuals. To explore, click a region or a quarter — everything updates together, and you cannot break anything: the data is on another sheet.»
To say while delivering; have the director click himself.
Step-by-step template — synchronized dashboard
1) Sheets: «Data» (structured table), «Pivot» (2 pivot tables), «Dashboard»
2) Pivot: PivotTable Analyze > Insert Slicer > Region
3) Right-click slicer > Report Connections > check PT_Sales + PT_Margin
4) PivotTable Analyze > Insert Timeline > Date
5) Copy visuals + slicers to «Dashboard», KPIs at the topFreelancer
Slicers + timeline and your clients explore alone, without risking the formulas.
SME in Algiers
Wassim delivers the weekly steering: the director filters by region and quarter with one click.
Project team
Require verified report connections before any dashboard delivery.
Beginner
This week: a slicer connected to two pivot tables + a timeline on the dates.
✓ Best practices
- Use slicers rather than hidden filters.
- Connect a slicer to several pivot tables.
- Separate the Data / Pivot / Dashboard sheets.
✗ Common pitfalls
- Unconnected slicers → desynchronized visuals.
- Piling everything on a single messy sheet.
- Too many slicers: keep the essential.
Key takeaways
- A slicer = a clickable visual filter connected to the pivot tables.
- The timeline filters by dates.
- A slicer can drive several pivot tables (report connections).
- Dashboard = indicators + visuals + slicers, on a dedicated sheet.
48h challenge — apply tomorrow
Add 1 slicer connected to 2 pivot tables and 1 timeline, then have a colleague use the file without help.
- My slicer filters visually, with one click.
- My timeline filters by shared dates.
- My dashboard fits on a dedicated sheet, synchronized.
Frequently asked questions
Can a slicer filter several pivot tables at once?
Yes: via «Report Connections» (right-click the slicer), you check all the pivot tables to drive. This is what makes a dashboard consistent: one click updates everything together.
Slicer or classic filter?
The drop-down filter is enough for occasional use; the slicer is visible, clickable and ideal for a dashboard handled by others — you see at a glance what is filtered.
What is a slicer used for?