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.

See also  What is Power Platform + Video tutorial

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

ColumnsData Types
DateData and time
RegionSingle line of text
ProductSingle line of text
QuantityNumber
Unit PriceCurrency
Total SalesCurrency
slicer in power bi

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.

Power BI sync slicers

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.

sync slicer power bi

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

sync slicer in power bi

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

power bi sync slicers on same page

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

sync slicers power bi

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

how to sync slicers in power bi

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.

what is sync slicer in power bi

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.

power bi how to sync slicers

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

Create a Sync Slicer in Power BI

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.

See also  Power BI Date Slicer [11+ Examples]

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

power bi apply slicer to all page visuals

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

power bi sync multiple 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.

sync multiple slicers in power bi

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

How to Sync a Slicer Across Multiple Pages in Power BI

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.

sync multiple slicers power bi

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

Power BI Sync a Slicer Across Multiple Pages

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.”

power bi remove sync slicers

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.

sync slicer in Power bi service

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.

how to Sync Slicers on the Power BI Service

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

How do I add Sync slicer to Power BI service

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.

Sync slicer working in Power BI Service

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

How do I sync slicer in Power BI Online

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

sync slicers panel on the power bi service

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

power bi service sync slicer

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

See also  Power BI Slicer Multiple Selection

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:

>