Skip to main content

Power BI

Needs Votes

Sync Drill-through page filters

Vote (156) 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 (11)
Дмитрий Соловьёв's profile image Profile Picture

00499e7b 629c-4b39-92e7-51110514d6e1 on 06 Jul 2020 00:17:16

RE: Sync Drill-through page filters

Please add this!!

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

89a32c8e 55a8-42b6-ab47-0c8779cc2f34 on 06 Jul 2020 00:16:33

RE: Sync Drill-through page filters

Would love for this to come to fruition... in the mean time I've been reworking my reports to leverage the cross-report drill through functionality. My summary pages are now stand alone reports and the drill through pages are all in a separate report, each with the drill through filter added. https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-cross-report-drill-through

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

b11bd275 1950-48a1-8970-de87c538319c on 06 Jul 2020 00:00:20

RE: Sync Drill-through page filters

Quite useful, please add this functionality!

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

ec74fa5b 71ed-4732-841f-a9da7f3eff03 on 05 Jul 2020 23:54:07

RE: Sync Drill-through page filters

Please add this soon. It's a much needed feature that would enable better adoption and use of Drillthrough.

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

ec9b48d5 9041-4896-bc90-13f0ac688776 on 05 Jul 2020 23:49:32

RE: Sync Drill-through page filters

Please add this functionality soon

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

a6389439 9682-4635-b34a-c658c8568b12 on 05 Jul 2020 23:47:20

RE: Sync Drill-through page filters

Wanna call everyone to vote this!
really needed now

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

186d345c 2b1f-476e-b095-01e0c8184d26 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

8ea9824e e7a3-4b65-8cc5-e67f23ddfb3b on 05 Jul 2020 23:45:37

RE: Sync Drill-through page filters

Very common scenario!

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

d89f7302 fb59-4d64-9e24-d3a6b1eac260 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

1c4b2b21 0eff-4a26-b01b-fdc25e36cb18 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.