How to Use Google Sheets Slicers to Filter Dashboards

The Interactive Dashboard Problem

You have just spent three hours building a beautiful sales dashboard in Google Sheets. It has four different charts and two pivot tables, all pulling from a master dataset of 5,000 rows. You share it with your manager.

Ten minutes later, your manager asks, “This is great, but can I see this exact dashboard filtered only for the European region?”

If you used standard column filters on your raw data, you have to go back to the dataset, filter the “Region” column for Europe, and wait for all the charts to update. If your manager then asks to see Asia, you have to do it again. You cannot expect a non-technical executive to safely navigate to the raw data tab and manipulate the core filters without accidentally breaking something.

To solve this, Google Sheets offers a powerful interactive tool called Slicers. A Slicer is a visual, floating button that sits directly on top of your dashboard. When a user clicks it and selects “Europe,” every chart and pivot table on the screen instantly updates. It makes your spreadsheet feel like a custom-coded web application.

Adding a Slicer

Before you add a Slicer, you must already have at least one chart or pivot table built on your sheet.

1. Click anywhere on your existing chart or pivot table to select it.
2. Go to the Data tab in the top menu.
3. Click Add a slicer.

A floating, pill-shaped button will appear on your spreadsheet. You can click and drag this button to position it neatly above your charts, creating a “control panel” aesthetic.

Configuring the Slicer

When the Slicer appears, a configuration menu will open on the right side of your screen.

1. Look for the Column dropdown menu in the sidebar.
2. Select the specific data column you want your users to be able to filter by. For example, select Region.

The floating button on your dashboard will now read “Region: All”.

How to Use the Slicer

Now, share the sheet with your manager. When they view the dashboard:

1. They click the floating Region Slicer button.
2. A clean dropdown menu appears listing all available regions (North America, Europe, Asia, etc.).
3. They click Clear to uncheck everything, then check the box next to Europe.
4. They click OK.

Instantly, every chart, graph, and pivot table connected to that dataset recalculates and redraws to show only European data. The raw dataset tab remains completely untouched and safe from accidental edits.

Customising the Slicer’s Appearance

Because Slicers are meant to be part of a visual dashboard, you can style them to match your company’s branding.

1. Click the Slicer button once to select it.
2. Click the three-dot menu in the top-right corner of the Slicer and select Edit slicer.
3. In the right sidebar, switch from the “Data” tab to the Customize tab.

Here you can change the background colour, the text font, and even hide the title. For example, if you have a dark-mode dashboard, you can change the Slicer background to dark grey with white text so it blends seamlessly into the design.

Do not force your team to dig through raw data just to change a filter. By adding Google Sheets Slicers to your files, you instantly upgrade a static spreadsheet into an interactive, professional dashboard that anyone can use safely and intuitively.