Skip to main content

Power BI

Needs Votes

Sync Drill-through page filters

Vote (206) Share
Дмитрий Соловьёв's profile image

Дмитрий Соловьёв on 26 Feb 2018 22:04:51

Scenario: I have an "Overview" page and 2 other pages with drill-through filters enabled ("Customer performance" and "Customer history"). End users want to be able to drill through from the Sales Overview to the Customer performance page and then just open the "Customer history" page and keep the same drill-through filter.

Comments (15)
Дмитрий Соловьёв's profile image Profile Picture

David S on 05 Jul 2020 23:45:56

RE: Sync Drill-through page filters

I have been trying to solve this same problem. I have an overview page that can drill-through to two pages. Those two pages have synced slicers. I want to be able to drill-through to one of them and then use a bookmark to access the other, keeping the drill-through filter. For some reason, when using a drill-through, the sync slicers component seems to break. Perhaps I am doing something wrong but that is what the issue seems to be.

Дмитрий Соловьёв's profile image Profile Picture

Martin on 05 Jul 2020 23:45:37

RE: Sync Drill-through page filters

Very common scenario!

Дмитрий Соловьёв's profile image Profile Picture

Power BI User on 05 Jul 2020 23:32:49

RE: Sync Drill-through page filters

I also face same issue like Ahussnain. I have question to Microsoft team which power BI update should I expect this functionality?

Thanks in advance!!!

Дмитрий Соловьёв's profile image Profile Picture

ahussnain on 05 Jul 2020 23:17:55

RE: Sync Drill-through page filters

I have multiple visuals on same page all showing hierarchical data for different KPIs. Let's say hierarchy is Regions -> Countries -> Products.

When I drill down on regionA in Visual1, I see list of all countries in A are shown, but the visual2 (with same hierarchy on x axis) gets filtered to regionA only (i.e. doesn't show the countries under it in Visual2). Similarly drilling further down on VisualA, doesn't drill down on Visual 2 automatically.
There should be a way to sync the drill through filters across visuals (same and different pages).
I believe so many of us design our reports in this fashion. Implementation of this feature is not complete without this sync feature.

Дмитрий Соловьёв's profile image Profile Picture

Power BI User on 05 Jul 2020 23:17:42

RE: Sync Drill-through page filters

This is a common scenario in the real world. hope this will be supported soon