Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
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?
Solved! Go to 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
Best Regards
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
Best Regards
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
123 | |
78 | |
49 | |
38 | |
37 |
User | Count |
---|---|
196 | |
80 | |
70 | |
51 | |
42 |