Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
GRCacace
Frequent Visitor

Keeping slicers synced between report pages?

We're using Power BI Embedded on Azure (recently deprecated, we know) to show clients certain reports. We have everything working as desired; however, these client reports have a few tabs/pages, and each tab/page has slicers on it that filter the view of the data. For example, one slicer may show Q1, Q2, Q3 or Q4, and the related slicer right next to it would show the campaigns that ran during that quarter.

 

What we're trying to figure out is whether the PBI API will allow us to sync those selections between report pages/tab?

 

So, on tab/page 1, the client may be looking at Q2/Campaign xyz; then the client clicks the next tab/page to go to another report view, but the slicer was previously set to Q1/Campaign abc. Is there a way for us to use the API to keep those slicers synced? The API exposes when the tab/page changed, but it doesn't seem to expose the individual tiles; you can get their IDs, but that's about it.

 

Any thoughts on whether this is possible?

2 REPLIES 2
Eric_Zhang
Employee
Employee


@GRCacace wrote:

We're using Power BI Embedded on Azure (recently deprecated, we know) to show clients certain reports. We have everything working as desired; however, these client reports have a few tabs/pages, and each tab/page has slicers on it that filter the view of the data. For example, one slicer may show Q1, Q2, Q3 or Q4, and the related slicer right next to it would show the campaigns that ran during that quarter.

 

What we're trying to figure out is whether the PBI API will allow us to sync those selections between report pages/tab?

 

So, on tab/page 1, the client may be looking at Q2/Campaign xyz; then the client clicks the next tab/page to go to another report view, but the slicer was previously set to Q1/Campaign abc. Is there a way for us to use the API to keep those slicers synced? The API exposes when the tab/page changed, but it doesn't seem to expose the individual tiles; you can get their IDs, but that's about it.

 

Any thoughts on whether this is possible?


@GRCacace

It is not about the API aspect, in Power BI, the sclier just can't work across pages. You can check this idea Slicer over all pages and vote it up.

Hi,

check out in the new version app. go to "View" tab -> Sync slicers.

then just select the slicer you're interested in and mark the "sync" boxes on the left on the pages you want it to be synced.

 

it is also available in the online GUI. go to "edit report" -> view -> Sync slicers pane, and it's the same.

 

very neat and essential feature.

good luck

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.