How to Link Filters in Power BI

Creating a Power BI report with multiple pages is a great way to organize your analysis, but it can quickly frustrate users if their filter selections don't carry over from one page to the next. Fortunately, Power BI has a built-in feature to solve this exact problem by syncing your slicers. This article walks you through how to link filters across different report pages, turning a disjointed collection of visuals into a smooth, interactive dashboard experience.

What Are Synced Slicers and Why Bother Using Them?

In Power BI, a "slicer" is a type of visual that allows users to filter the data presented in other visuals on the page. Out of the box, a slicer only affects the page it's placed on. If you want the same filter to apply to another page, you'd typically have to create a copy of that slicer on the new page, forcing the user to make the same selection twice.

This is where synchronizing slicers comes in. The "Sync slicers" feature allows you to link a single slicer's selection across multiple pages. When a user filters by "East Region" on your main summary page, every other page you’ve synced will also automatically be filtered to show data for the East Region.

Why is this so important?

• Better User Experience: It creates a seamless and intuitive navigation path. Users feel like they are interacting with a single, cohesive application rather than a series of disconnected reports. They make a selection once, and it sticks with them as they explore the data.
• Saves Report Canvas Space: You don’t need to clutter every single report page with the same set of slicers (e.g., Date Range, Region, Product Category). You can place them on a main "dashboard" page or a dedicated filters page, and their influence will be felt everywhere else.
• Ensures Consistency: It eliminates the risk of users forgetting to apply a filter on a specific page, which could lead them to draw a wrong conclusion from the data. If the "2023" filter is synced everywhere, they won't accidentally look at 2022's data on the "Product Details" page.

A Step-by-Step Guide to Synchronizing Slicers in Power BI

Let’s walk through a practical example. Imagine we have a simple three-page sales report:

1. Sales Overview: A high-level dashboard with key performance indicators (KPIs).
2. Regional Breakdown: A page with maps and charts showing sales performance by state or country.
3. Product Analysis: A deep dive into sales by product category and sub-category.

Our goal is to add a "Product Category" slicer to the "Sales Overview" page and have its selection apply to the other two pages.

Step 1: Create Your First Slicer

First, we need the slicer itself. Navigate to your primary report page (in our case, "Sales Overview").

1. Go to the Visualizations pane on the right-hand side.
2. Click on the Slicer icon. A blank slicer will appear on your report canvas.
3. With the new slicer selected, drag the field you want to filter by from the Data pane into the Field well of the slicer. For our example, we'll drag in "Product Category".
4. Resize and format the slicer as you see fit. You now have a working slicer that filters everything on the "Sales Overview" page.

Step 2: Open the "Sync Slicers" Pane

Now, let's make this slicer work across our other pages. The controls for this are located in a dedicated pane.

1. Go to the View tab in the main Power BI ribbon at the top of the window.
2. In the "Show panes" section, click the checkbox for Sync slicers.

A new "Sync slicers" pane will appear on the right, typically next to your Visualizations and Data panes. Selecting your slicer from Step 1 will now populate this new pane with options.

Step 3: Understanding the "Sync Slicers" Controls

When you select your "Product Category" slicer on your first page, you'll see a list of all the pages in your report inside the Sync Slicers pane. Next to each page name, there are two checkboxes with icons:

• Sync (a refresh icon): This is the most important column. Checking this box means that any selection made in this slicer will also apply to that page. If you select "Apparel" on the "Sales Overview" page, the "Regional Breakdown" page will also be filtered for "Apparel." This is the core of linking filters.
• Visible (an eye icon): This column controls whether the slicer visual itself appears on that page. It’s simply a shortcut for copy-pasting the slicer. Checking this box will make a copy of the slicer appear in the exact same position on the checked page.

Step 4: Configure Your Slicer Syncing

Using these two columns, you can achieve your desired filtering behavior. For our example, we want the single slicer on the "Sales Overview" page to act as a "global" filter for the entire report. Here's how to set it up:

1. Select the "Product Category" slicer on the "Sales Overview" page.
2. In the Sync slicers pane, you'll see your three pages: "Sales Overview," "Regional Breakdown," and "Product Analysis."
3. By default, both the sync and visible checkboxes will be checked for the current page ("Sales Overview"). Leave this as is.
4. For the "Regional Breakdown" page, check the box in the Sync (refresh icon) column, but leave the box in the Visible (eye icon) unchecked.
5. Do the same for the "Product Analysis" page: check Sync, uncheck Visible.

That's it! Now, go test it out. Select a category on the "Sales Overview" page. When you navigate to the "Regional Breakdown" or "Product Analysis" pages, you will see that all the visuals are correctly filtered, even though the slicer visual itself is not present. You've successfully created a centralized filter.

Advanced Techniques & Best Practices

Once you've mastered the basics, you can apply more advanced strategies to create even more powerful reports.

Grouping Slicers for Independent Control

What if you have multiple sets of slicers that shouldn't interact with each other? For instance, you might have another "Date" slicer that you also want to synchronize. By default, Power BI considers all synced slicers of the same field to be part of one group.

You can create named groups to keep them separate. In the Sync Slicers pane, click on Advanced options. This reveals a box where you can type in a group name. Slicers sharing the same group name will sync with each other, but not with slicers in a different group.

Example Scenario: You have a "Customer Segment" slicer on page 1 and a "Region" slicer on page 2. Let's say you want to sync any "Region" slicers you add across the report, but you want the "Customer Segment" slicer to remain independent. You could create a group called "Geography" and assign it to every region-based slicer you create.

Best Practices for a Great User Experience

• Indicate Hidden Filters: The biggest drawback of syncing hidden slicers is that users might be confused about why their data looks filtered. If they land on page 3 directly, they won't know that a filter from page 1 is active. A simple solution is to add a text card to each page that displays the active filter selection. You can do this with a simple DAX measure, like:
• Be Mindful of Performance: While incredibly useful, having dozens of slicers synced across a 20-page report can introduce a small amount of lag, as Power BI has to evaluate the filter context across more pages. Use syncing strategically for essential filters and avoid overdoing it on massive reports.
• Check Your Data Model: Remember, slicers and filters only work if the underlying tables in your data model are correctly related. If your Product slicer isn't filtering your Sales table, the issue likely isn't the sync settings, it's a missing or inactive relationship between the 'Products' and 'Sales' tables in the Model view.
• Create a Dedicated Filter Page: For complex reports, many designers create a dedicated "Filters" page that holds all the primary slicers. They then sync these slicers across the entire report while keeping them hidden everywhere else. This provides users one central place to set their criteria before diving into the analysis pages.

Final Thoughts

Learning to sync slicers in Power BI elevates your reports from simple data displays to truly interactive analytical tools. It's a fundamental skill that reduces clutter, ensures consistency, and provides a much more professional and intuitive experience for anyone using your dashboards.

Of course, mastering all the details of dashboard tools like Power BI takes time away from acting on the data itself. At Graphed, we found ourselves spending hours wrangling visuals and syncing filters when all we wanted were quick answers. We built Graphed to automate this process. Instead of manually building reports, you can connect your data sources in seconds and simply ask questions in plain English - like "Show me our top-selling product categories by region for last quarter" - and get a real-time, interactive dashboard built for you instantly.