Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.

Reply
Lakshmanan1
Helper I
Helper I

Subreport has drill through capability, but when I click the back button,it takes me to the main rpt

Hi,

I possess Report A and Sub Report B, C, D.

Within sub report B, C, D, I have inserted a drill through in the 'Total' cell. Clicking the Total cell in each sub report B, C, or D will navigate to drill through report Z.

Upon viewing drill through Report Z, if I select 'Back', it should return to the specific Sub report from which I accessed the drill down link. Instead, it currently directs back to Main Report A.

 

Can you please suggest a solution for achieving this? 

2 REPLIES 2
Lakshmanan1
Helper I
Helper I

@hackcrr  drill down report is not possible, since the drill through reports are in different template.... So I have to go with Drill through report.... hence When  I click 'Back', button it should return to the specific Sub report from which I accessed the drill down link.Instead, it currently directs back to Main Report A.

Can you please suggest a solution to achieve this? 

Lakshmanan1_0-1725436712871.png

 

hackcrr
Super User
Super User

@Lakshmanan1 

You can refer to the following official documentation for a tutorial on this feature:

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/drillthrough-drilldown-su...

hackcrr_0-1725376143464.png

 

https://learn.microsoft.com/en-us/power-bi/paginated-reports/report-design/drilldown-action-report-b...

hackcrr_1-1725376153438.png

 

If I have answered your question, please mark my reply as solution and kudos to this post, thank you!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.