How to Sync Slicers in Power BI? [With Examples]

Power BI is a powerful tool made by Microsoft for showing data and better understanding the business. It has many useful features to improve reports.

One such feature is sync slicers, which allows users to synchronize Slicer across multiple report pages or visuals within a report.

This tutorial will teach us about the Power BI sync slicer and how to sync slicers in Power BI.

Additionally, we will see how to sync a slicer across multiple pages in Power BI and how to remove sync slicers in Power BI.

Sync Slicers in Power BI

Sync Slicers in Power BI like a set of controls you use to filter data in our reports. Imagine you have multiple pages or visuals in your Power BI report and want to filter them all based on certain criteria, like a date range or a specific category.

Sync Slicers allow you to link these filters together so that when you change the filter in one place, it automatically updates all the other connected visuals or pages.

How to Sync Slicers in Power BI

In this example, we will explore how to sync slicers in Power BI.

Scenario:

Let’s say you’re analyzing sales data for a company that sells products in different regions. You have a Power BI report with multiple pages showing sales performance by region, product category, and time period.

According to this scenario, we have a SharePoint list named Electronics Sales Data that contains the following columns with various data types:

Columns	Data Types
Date	Data and time
Region	Single line of text
Product	Single line of text
Quantity	Number
Unit Price	Currency
Total Sales	Currency

Now follow the below steps to Sync Slicers in Power BI:

1. Open Power BI Desktop and load data using the Get data options. The data set will then appear in the Data panel.

2. I want to create two slicers with the same value here. To do this, Under the Home tab, expand the Visual gallery(black box) -> Click the Slicer.

3. Using the +Add data option, add the Region into the Field.

4. Make a duplicate slicer using ctrl+c and ctrl+v on the same page.

5. After that, under the View tab, click “Sync slicers.” A Sync slicers pane will open.

6. When you select a slicer, the Sync slicer panel displays some properties and advanced options.

7. After that, check the sync option for Page 1. Then you can see that the Advanced options automatically take the group name as Region.

8. Next, choose another slicer. Then, make sure to select the Sync option. In the Advanced options settings, automatically set the group name as Region 1, and then give the group name as Region.

9. Now, you see that when you select a particular region in one slicer, the other one automatically selects the same data.

In this way, we can Sync Slicers in Power BI.

How to Sync a Slicer Across Multiple Pages in Power BI

Here, we will explore how to sync a slicer across multiple pages in Power BI.

Using this SharePoint List, I have created two Page Power BI reports.

1. Select the Slicer (Date). After that, under the View tab, click Sync Slicers.

2. In the Sync slicer panel, under the sync icon, check the box, expand the Advanced option, and provide the group name. In my case, I am given the name Date.

3. Next, choose another page. Then, select the Slicer. In the Advanced options settings, automatically set the group name as Date.

4. Now, our sync slicers across multiple pages are completed. To check this, you can filter the pages in the report. In my case, I selected 18/03/2024 in the Page 1 Slicer.

5. Page 2 automatically filtered. Check in the screenshot below.

In this process, you can sync a slicer across multiple pages in Power BI.

Unsync Slicers Power BI

Now we see how to unsync slicer in Power BI.

I believe “unsync slicer” refers to removing the synced slicer in Power BI.

Follow the below steps Power BI remove sync slicers.

Choose a slicer that is initially synced. Then, go to the “Sync slicer” pane and uncheck the box next to “Sync.”

This is how to remove the sync slicer in Power BI.

Sync Slicers on the Power BI Service

We can’t use sync slicers on the dashboard, but we can create one in the Power BI service.

Follow the below steps to use sync slicers in the Power BI service:

I hope you follow the above example of how to sync a slicer across multiple pages in Power BI.

1. Under the Home tab, click Publish.

2. If you’re not logged in to Power BI service, log in using your work or school account. Then, Select My workspace and click on the Select button.

3. Next, go to the Power BI Service and choose the report that we’ve published.

4. To check this, you can filter the pages in the report. In my case, I selected 3/02/2024 in the Page 1 Slicer.

5. Page 2 automatically filtered. Check in the screenshot below.

6. If you need to make any changes in the sync slicer panel, click on “Edit.”

7. Click “View,” then activate the “Sync slicer Pane” button. You’ll then be able to see the Sync slicers pane.

This way, you can use the sync slicer in Power BI Service.

Conclusion

Sync slicers in Power BI are a valuable feature that enhances data analysis and reporting capabilities.

This tutorial taught us Sync Slicers in Power BI and how to apply it. Also, we learned to sync a slicer across multiple pages in Power BI and how to remove sync slicers in Power BI.

Also, you may like some more articles:

• Power BI Date Slicer
• Power BI Slicer Sort Descending
• Remove Blank From Power BI Slicer
• Power BI Slicer Multiple Selection
• Create Card Visual in Power BI