Drillthrough – how to keep the same filter when navigating to additional detail pages

[TalC]

Hi everyone,

I’ve set up a drillthrough in Power BI where users can start from a table on the main page, right-click an account, and drillthrough to an Account Detail page. That part works fine — the selected account is correctly filtered on the detail page.

The issue:
From that detail page, I’d like users to be able to go to additional related detail pages while keeping the same account filter.

Right now:

• Drillthrough only works once. On the second page, the filter context is lost unless I force the user to reselect from a table again.

• I tried syncing slicers across pages, but that requires the user to actually tick the slicer first, and it doesn’t automatically update when drillthrough passes a new account. This causes the slicer to “stick” to the previous selection.

What I want:
A way for the account selected via drillthrough to automatically carry over to other detail pages without requiring slicer clicks. Ideally, users would:

1. Drillthrough from the main table → Account Detail page.

2. Use navigation buttons (or bookmarks) on the Account Detail page → other detail pages.

3. The same account filter automatically applies everywhere.

Is there a clean way to make the drillthrough selection persist across multiple pages?

Thanks in advance!

[TalC]

Hi all,

I was able to get a half elegant solution using a synced slicer.
What I did was setup a slicer on the first drill-through target page, I used the new button slicer visual and checked single select and force selection options.
When the user drills through, the slicer doesn't automatically get selected but its already showing the account filtered from the drill through so just one click is needed to "activate" it.
From there I added navigation buttons to each destination page and synced the slicer across all those pages.

Hope this helps and thanks for the contributions!

[V-yubandi-msft]

Hi @TalC ,

Your response has been helpful. If you can, please mark it as the accepted solution so it can benefit others in the community who view this thread.

Thank you.

[V-yubandi-msft]

Thank you for sharing your experience and the workaround. We appreciate you taking the time to add your insights to the community. Your feedback and solution are valuable for others facing similar challenges.

Regards,
Yugandhar.

[V-yubandi-msft]

Hi @TalC ,

Thank you for engaging with the Microsoft Fabric Community. As @danextian , mentioned earlier, drillthrough filters are only applied to the page you drill into they don't continue if you use buttons or bookmarks to navigate further, which is why the filter context appears to be lost.

Some responses suggested using synced slicers or disconnected tables as alternatives. To clarify

1. Drillthrough does not automatically select slicer values.

2. You can use a disconnected table or a hidden synced slicer to replicate the effect, but this requires extra configuration and won’t function exactly like the built in drillthrough feature.

Currently, there isn’t a built in method to keep drillthrough filters active across multiple detail pages.

Thank you all for your insights and contributions to this discussion.

Best Regards,

Yugandhar.

[Poojara_D12 · Accepted solution]

Hi @TalC 

Drillthrough in Power BI only applies the filter to the first target page, so it won’t persist when moving further. To keep the account filter across multiple detail pages, you can sync a hidden slicer (for Account) across all relevant pages and let the drillthrough populate it, or use a disconnected parameter table to capture the selected account and drive filtering everywhere. This way, when users navigate with buttons or bookmarks, the same account context is retained automatically without extra clicks.

[danextian]

hI @TalC 

What you're trying to achieve currently isn't supported. Drillthrough filters are not carried over to another page unless the transfer to another page originates from a  drillthrough action. Also, a visual cannot crossfilter another visual if it is hidden so using bookmarks to affect the visibility of visuals within the same page won't work either.