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
TomSinAA
Helper IV
Helper IV

Drill through to multiple pages

Hello,

 

I am an trying to setup a drill through that would allow the user to see multiple pages they can drill through to.  But each page is based on a different table.  However the tables have common fields.  So I can create a drill through to the first target page:

TomSinAA_0-1654523940331.png

In the above drill through, the % of Pickups and Deliveries - Detail uses the same table as the drill through source page.

 

I have another detail page that I would like to allow users to select as a drill through. That page uses a different table as it's source but it has several columns in common with the drill through source page above.  Such as Region, Ship From, Ship To, Site as shown below.  When I add these columns in the target page as the drilldown fields, the report does not list this page as a drilldown target.

 

 

TomSinAA_1-1654524139386.png

 

Thanks

 

3 REPLIES 3
amitchandak
Super User
Super User

@TomSinAA, Not very clear. But the drill-through report should have one of these columns in drill-through report section of the page  

 

drillthrough_02

 

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Thanks @amitchandak ,

 

The target page does have the drill through field in it.  

Hi @TomSinAA ,

 

Please mark sure the drill through field comes from the same table in that row you right click.

 

Or you can share you pbix file without sensitive data if you need more help.

 

Best Regards

Community Support Team _ chenwu zhu

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

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!

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.

Top Solution Authors