Forum Discussion
Post ProdigyHow can I drill through from one table to another
hi,
I have a table1 on one page called Domain and has a field called BusinessDomain.
I have table2 on a 2nd page called DomainChildren and it also has a field called BusinessDomain.
I've established a one-to-many relationship between table1 to table2 based on these fields (parent-child relationship).
On the 2nd page I put the BusinessDomain field from DomainChildren on the drill through portion, but I am not seeing from page 1 the drill through option on BusinessDomain ?
Thanks
Hii EaglesTony
You can drill-through from one table to another as long as the target page contains a Drill-through filter based on a field that is related to your first table.
Add a Drill-through field to the target page >> enable “Allow drill-through” >> then right-click any row in the first table and you’ll see the drill-through option.
Just make sure both tables are connected in the data model through a relationship; otherwise drill-through will not appear.
5 Replies
rohit1991Super User
Hii EaglesTony
You can drill-through from one table to another as long as the target page contains a Drill-through filter based on a field that is related to your first table.
Add a Drill-through field to the target page >> enable “Allow drill-through” >> then right-click any row in the first table and you’ll see the drill-through option.
Just make sure both tables are connected in the data model through a relationship; otherwise drill-through will not appear.- Kedar_Pande
Page 2 (DomainChildren) setup:
Page info (top bar) → Add drill-through fields
Drag DomainChildren[BusinessDomain] to drill-through field
Page 1 (Domain) setup:
Right-click Domain[BusinessDomain] visual → Drill through → select Page 2
Or add drill through button → Action → Drill through → Page 2
If this answer helped, please click Kudos or Accept as Solution.
-Kedar
LinkedIn: https://www.linkedin.com/in/kedar-pande Hi EaglesTony ,
Thanks for your question. The drill-through feature can be a bit tricky, and a few common setup issues may prevent the option from appearing. Let’s go through the key checks.
1. Confirm the drill-through field comes from the same table used on Page 1
Even though you have a relationship between Domain → DomainChildren, drill-through only works when the field used for drill-through matches exactly the field used in the source visual — same table, same column.
On Page 1, if you're using Domain[BusinessDomain], but your drill-through field on Page 2 is DomainChildren[BusinessDomain], Power BI will not show the drill-through option.
Fix:
Use Domain[BusinessDomain] as the drill-through field on Page 2, not the child table column.2. Make sure the column is added to the “Drill Through” well
On Page 2:
Select a blank area
Drag Domain[BusinessDomain] into the Drill through > Add drill-through fields here section
Power BI will automatically create a back button
3. Check your source visual
The drill-through option will only appear when you right-click a data point in a visual that actually contains the same field placed in the drill-through pane.
Why the child table column doesn’t work
The drill-through action is context-based.
Power BI must pass the exact value of the same column (same table, same lineage) to the target page.
Even with 1-to-many relationships, drill-through cannot pass a column from a different table unless that column is the one used in both places.If this still doesn’t work
Please share a small sample PBIX or mock data showing both tables and the relationship.
It doesn’t need to contain real data — just enough structure so we can reproduce the behavior.Regards,
Nadeem
Did I answer your question? If so, please mark this reply as a solution to help others.
v-karpurapudCommunity Support
Hi EaglesTony
I would also like to thank you rohit1991 , Kedar_Pande and mnadeemsalam for your active participation and for sharing solutions within the community forum.
I hope the information provided helps resolve your issue. If you have any further questions or need additional assistance, please feel free to contact us. We are always here to help.
Best regards,
Community Support Team- v-karpurapud
Hi EaglesTony
We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.
Thank You.
