How can I drill through from one table to another

[EaglesTony]

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

[v-karpurapud]

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

[mnadeemsalam]

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.

[Kedar_Pande]

@EaglesTony 

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

[rohit1991]

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.