Forum Discussion

EaglesTony's avatar
EaglesTony
Icon for Post Prodigy rankPost Prodigy
9 months ago
Solved

How 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...
Need Help
  • rohit1991's avatar
    rohit1991
    9 months ago

    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.

     

mnadeemsalam's avatar
mnadeemsalam
Frequent Visitor
9 months ago

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.