Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hi all,
I have about 15 reports that require drill-through functionality (users want the ability to drill-through to more detailed information). Rather than add the detailed drill-through report to each report individually (and therefore maintain 15 copies), I would like to implement a 'shared' report and use cross-report drillthrough functionality.
The problem is, the back arrow to navigate to the previous report doesn't seem to work with cross-report drillthrough.
The documentation states: "
If you want to return to the source report after the cross-report drillthrough action, use the browser's Back button."
Hoping someone could please suggest a way around this (so that the navigation action navigates to the previous report, rather than using the browsers back arrow)?
Kind regards,
Ben.
Hi all,
Thanks very much for your replies and suggestions, they are most helpful. I was hoping that there would be a native solution for cross-report drill-through that didn't involve workarounds or custom code/scripts. Hopefully this gets addressed by MS in the near future.
Kind regards,
Ben.
Hi @bhalicki ,
Thank you for the prompt responses.
Regarding the need for a native solution to support cross-report drillthrough with the ability to return to the source report in Power BI, I recommend submitting this scenario as a feature request on the official Power BI Ideas forum. The Product Team actively monitors submissions there, and suggestions with strong community support are often considered for future updates.
Hi @bhalicki ,
Just following up to see if you had a chance to vote for the cross-report drillthrough / return to previous report with page navigation feature in the Ideas forum.
Let me know if you’ve already submitted it or need any help happy to assist!
Best regards,
Lakshmi
Hi @bhalicki ,
Power BI doesn’t currently support a built-in way to programmatically navigate back from a cross-report drillthrough; the back arrow only works within the same report. As the docs say, the browser’s Back button is the only way to return to the source report after a cross-report drillthrough.
Workarounds:
You can add a “Home” or “Return” button in your shared drillthrough report, but it will need to use a bookmark or external URL. However, this can only take users to a fixed report/page (not the exact page they came from), since Power BI doesn’t track the previous report context for navigation actions.
Some users set up a landing page with links back to all main reports, to help with navigation.
If your organization has Power BI Embedded or custom web app integration, you might be able to control navigation via code—but this isn’t possible in the standard Power BI Service.
Hi @bhalicki ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for your prompt response
If the native back button doesn’t cut it in a cross-report drillthrough setup, one workaround is to manually add return buttons in the target report these can link back to the source report using a Web URL and helpful labels like Return to Summary Report. While this opens in a new tab by default, you can take things further by embedding your reports in a custom app or web portal. That way, you gain full control over navigation using JavaScript or routing logic, allowing users to seamlessly jump between reports as if there were a true Back function.
Solved: Cross report drillthrough. return button - Microsoft Fabric Community
Solved: how to use a button for a cross-report drillthroug... - Microsoft Fabric Community
Use cross-report drillthrough in Power BI Desktop - Power BI | Microsoft Learn
If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.
Looking forward to your response.
Best regards,
Lakshmi
Hi @bhalicki From what I know, Power BI doesn’t support a native “Back” button for cross-report drillthrough.
You can add manual return buttons using web URLs to simulate navigation back to the source report. Another option is using a central landing page for consistent navigation across reports. For advanced control, embed reports in a custom app to manage navigation programmatically.