Power BI – Sync Slicers

Power BI ‘Sync Slicer’ synchronized the all pages where this filter or slicer have been applied. This feature was introduced in the February 2018 update of Power BI Desktop.

Furthermore, it helps optimize query processing by minimizing round trips to the database. In essence, with this feature, the slicer query impacts the database only twice: first during page loading and then upon selecting a value from the slicer.

Let’s start with an example:

Imagine you have a report containing 15 to 20 pages, and you want to observe the results for a specific category of products across all those pages. Without the use of sync slicers, you’d need to manually choose the same category individually on each page, which can be quite time-consuming.

However, in this scenario, sync slicers prove to be highly beneficial. They allow you to synchronize the selected value of a slicer across all the pages where you have implemented this feature.

This means that by selecting a category once, it instantly updates and reflects the chosen category throughout all the related pages. This significantly streamlines the process and saves you time and effort.

Let’s get started-

Suppose you have two pages in your report, see below images for your reference-

Page 1: Refer below image for Page 1 visual details.

Page 2: Refer below image for Page 2 visual details.

To enable Sync Slicers, follow these steps:

Step-1: Open Page 1.

Step-2: Navigate to the View tab and click on “Sync slicers.”

Step-3: Once you have done that, choose the “Year” slicer. After selecting the slicer, a Sync slicers screen will appear on the right side, as shown in the screenshot below.

Now, proceed to check the “Sync” option for both Page 1 and Page 2.

It offers the following three options:

• Add and Sync with All Pages: Enables the slicer to be synchronized across every page of the report.
• Visible: Permits the slicer to be visible only on the selected page.
• Sync: Allows the slicer to be synchronized on the chosen page (even though it remains invisible).

Step-4: In Page 1, choose a specific year using a slicer. The Sync slicer feature will automatically apply the selected slicer value from Page 1 to the slicers on Page 2, eliminating the need to manually select the slicer value on Page 2.

Hope you enjoyed the post. Your valuable feedback, question, or comments about this post are always welcome or you can leave us message on our contact form , we will revert to you asap.

Recommended Post:

Power BI Group

Hierarchies in Power BI