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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

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
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

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

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.