Forum Discussion
Keeping slicers synced between report pages?
Microsoft 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?
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