Forum Discussion
Solved
Create Parent/ Child drill down in Table visual
Can I create a Parent/Child drill down in the Table Visual or in a different Visual? Parent Child1 Child2 Parent Child1 Child2 Child3 Thanks
Hi MEFOX ,
yes you can.
I would recommend you the following DAX Pattern.
https://www.daxpatterns.com/parent-child-hierarchies/
Hi MEFOX .
for this you have to use the expand from the drilldown feature.
You must then save the report in the desired view.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill
Here it is as a table.
Here it is after I convert to a matrix.
I'm trying to get to something like this.
| Full Name | NetworkValue | # of Networks |
| Michael | Investment Strategy | |
| Private Trust | 2 |
This great! Is there a way to force it to expand on the child when the report opens without clicking on the + icon?
Hi MEFOX .
for this you have to use the expand from the drilldown feature.
You must then save the report in the desired view.
https://docs.microsoft.com/en-us/power-bi/consumer/end-user-drill