How to Link Slicers in Power BI

Constantly reapplying the same filters as you navigate between pages in a Power BI report is a well-known headache for both creators and users. This redundancy not only disrupts your analysis but also opens the door for inconsistency and errors. This guide will walk you through exactly how to link or "sync" your slicers across multiple report pages, creating a seamless and intuitive filtering experience for everyone.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

First, a Quick Refresher: What is a Power BI Slicer?

Think of slicers as user-friendly filters directly on your report canvas. Instead of having to open a filter pane, users can click buttons, select from a dropdown list, or use a date slider to instantly filter the data shown in other visuals on the page. They are the building blocks of an interactive report, allowing end-users to explore data from different angles without needing to edit the report themselves.

When you add a slicer on an individual page, by default it only affects the visuals on that specific page. But what if you have a report with a dozen pages, and you want a single "Year" slicer to control all of them? Manually adding and applying that filter on every single page is not a sustainable solution.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

The Common Problem: Disconnected Filters

Let’s imagine you're a marketing manager analyzing a recent product launch. Your Power BI report has several pages:

• An Overview page with top-line metrics like website traffic, ad spend, and total conversions.
• A Facebook Ads page drilling down into campaign performance, ad set metrics, and creative results.
• A Google Analytics page showing user behavior, top landing pages, and goal completions.
• A Sales Data page connecting ad performance to actual revenue from your Shopify store.

You start on the Overview page and use a slicer to filter the report for a specific marketing campaign, "Spring 2024 Launch." Then, you navigate to the Facebook Ads page to see which specific ads performed best. Uh oh. The data you're seeing is for all campaigns, not just the one you selected. You have to find the campaign slicer on this page and re-select "Spring 2024 Launch." You repeat this entire process for the Google Analytics and Sales Data pages. This repetitive clicking is not just annoying - it kills your train of thought and makes the report feel clunky and disjointed.

The Solution: The "Sync Slicers" Pane

Fortunately, Power BI has a built-in feature designed to solve this exact problem: the Sync slicers pane. This simple but powerful tool lets you make a slicer on one page control visuals on any other page you choose. You can have one central slicer that governs the entire report, ensuring your context - whether a date range, product category, or sales region - remains consistent as you explore your data.

Once you understand how this works, you'll be able to create much more sophisticated and user-friendly dashboards.

Step-by-Step Guide: How to Link Slicers in Power BI

Let's walk through the process using our marketing report example. We want a single campaign slicer on our "Overview" page to filter the visuals on the "Facebook Ads," "Google Analytics," and "Sales Data" pages.

Step 1: Create Your Primary Slicer

Start by creating the main slicer that will serve as the controller. Select the page where you want the "main" slicer to live. In our example, this is the Overview page.

1. Click a blank space on your report canvas.
2. In the Visualizations pane, select the Slicer icon.
3. Drag the data field you want to filter by into the "Field" well of the slicer visual. For our example, we would drag the "Campaign Name" field from our data source.
4. Format your slicer as needed (e.g., change it to a dropdown, adjust the colors, etc.). Now you have your slicer, but it still only works on the Overview page.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 2: Open the Sync Slicers Pane

Now, it's time to tell Power BI which pages this slicer should control. To do this, you need to access the Sync slicers pane, which is sometimes hidden by default.

1. Make sure your slicer from Step 1 is selected.
2. Go to the View tab in the Power BI ribbon at the top of the screen.
3. In the "Show panes" section, click the checkbox for Sync slicers.

A new pane will appear, typically next to your Visualizations and Data panes.

Step 3: Understand the Sync Slicers Options

This pane is simpler than it looks. You will see a list of all the pages in your report. For each page, there are two checkboxes represented by different icons:

• Sync (Refresh-like Icon): This is the most important column. Checking this box means that any filter applied to the selected slicer will also apply to the visuals on that page. It links the slicer's effect across pages.
• Visible (Eyeball Icon): This column controls whether the slicer itself is visible on each page. You can sync a slicer's filtering logic to a page without cluttering that page with the slicer visual itself.

Think of it this way: Sync makes the filter work on a page, and Visible makes you see the slicer on that page.

Step 4: Configure the Sync and Visibility Settings

Let's configure our campaign slicer. With the slicer on our "Overview" page still selected, look at the Sync Slicers pane.

1. The row for "Overview" is already checked for both Sync and Visible, because that’s where we created the slicer.
2. Find the row for "Facebook Ads." Check the box in the Sync column. We’ll leave the Visible box unchecked for now.
3. Find the row for "Google Analytics." Check the box in the Sync column.
4. Find the row for "Sales Data." Check the box in the Sync column.

That's all it takes! Now, when you select the "Spring 2024 Launch" campaign on your Overview page slicer, the charts on the other three pages will instantly filter to show data only for that campaign, even though the slicer visual itself doesn't appear on those pages.

Advanced Tips and Best Practices

Creating a Dedicated "Filters" Page

A common design pattern in professional Power BI reports is to create a dedicated page specifically for filters. Users can go to this page, set all their desired filters (e.g., date-range, region, business unit), and then navigate through the rest of the report with that context applied everywhere.

To do this:

1. Create a new page named "Filter Page" or something similar.
2. Add all the slicers you want to act as global filters onto this page.
3. For each slicer, go to the Sync slicers pane and check the "Sync" box for every other page in your report that should be affected.
4. Make sure the "Visible" box is only checked for the "Filter Page" itself to keep your data pages clean. No one wants to see ten slicers taking up a third of the screen on every page.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Linking Existing Slicers Across Pages

What if you've already built a report and have identical slicers on different pages but they aren't linked? Instead of deleting them and starting over, you can group them.

1. Manually go to each page where the slicer exists. Select the slicer by clicking on it.
2. Go to the Sync Slicers pane. You will see an "Advanced options" section at the bottom.
3. Here you can create a group name, like "Global_Campaign_Filter". Type this name into the box for your slicer on Page 1.
4. Now, go to the slicer on Page 2 and type the exact same group name into its advanced options.

Slicers with the same group name will stay in sync with each other. A change to one will be treated as a change to all others in the group.

Performance Considerations

While syncing slicers is incredibly useful, be mindful of performance. Every interaction with a synced slicer forces Power BI to re-query the data for all visuals on all synced pages. If you have a large dataset and dozens of complex visuals, having too many synced slicers can introduce a slight lag. Use them where they offer the most value but avoid syncing slicers that are only needed on a single page.

Final Thoughts

Linking slicers in Power BI is a fundamental skill that elevates your reports from simple data visualizations to truly dynamic and user-friendly analytical tools. By using the Sync Slicers pane, you create a cohesive and intuitive experience that saves time, prevents errors, and allows users to maintain their analytical focus as they move through different aspects of your data.

While linking slicers in tools like Power BI is a massive time-saver compared to manual report building, the initial setup can still involve a lot of clicks and configuration. At Graphed , we built our tool to remove these manual steps entirely. Instead of tweaking settings in various panes, you can just use plain English to ask for what you need - for instance, "Show me a dashboard comparing our spring campaign's ad spend against sales, with pages broken out by ad channel." Graphed instantly builds the live, interactive dashboard for you, with all the necessary filters already synced.