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

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
janeAlice
New Member

How to drill through and retain values from multiple rows

Hi, I have 2 tables. Table Child and Table Parent. They're names of children and their respective parents. In my child table, each child always has two parents.

 

The child table looks like this:

 

child_idchild_nameparent_id
1Larry Smith8
1Larry Smith9

 

The parent table looks like this:

 

parent_idparent_namechild_id
8Ginnie Smith1
9John Smith1

 

In the above, Ginnie and John are the parents to Larry. 

 

How would I go about setting this up in a Power BI table visual, where when I right click and drill through on Larry, it would take me to a new page where both Ginnie and John are simultaneously listed at once?

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @janeAlice ,

I created a sample pbix file(see the attachment), please check if that is what you want.

yingyinr_1-1679278878799.png

 

In addtion, you can refer the following links to get it.

Set up drillthrough in Power BI reports

Drill Through in Power BI

yingyinr_0-1679278727647.png

Best Regards

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @janeAlice ,

I created a sample pbix file(see the attachment), please check if that is what you want.

yingyinr_1-1679278878799.png

 

In addtion, you can refer the following links to get it.

Set up drillthrough in Power BI reports

Drill Through in Power BI

yingyinr_0-1679278727647.png

Best Regards

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

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