How to drill through and retain values from multiple rows

[janeAlice]

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_id	child_name	parent_id
1	Larry Smith	8
1	Larry Smith	9

The parent table looks like this:

parent_id	parent_name	child_id
8	Ginnie Smith	1
9	John Smith	1

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?

[Anonymous · Accepted solution]

Hi @janeAlice ,

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

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

Set up drillthrough in Power BI reports

Drill Through in Power BI

Best Regards