Forum Discussion
Drill Through Page Multi Layer
I have one table contain two column are activity id and predecessor column, one activityid can have many predecessor and predecessor is in the part of activityid if i want to click activityid to see the predecessor of each activityid and click the predecessor of each activity again for example
When click drill through value A will see B and C abd then click drill through value C will see D and E.
Hi Jidapa18
Yes. This is a Parent -> Child (Recursive) Drillthrough scenario.
You have:
- ActivityID
- Predecessor (which is also an ActivityID)
You want:
- A → B, C
- C → D, E
- (multi-level drill)
Solution:
1) Create a Self Relationship TableDuplicate the table in Power Query:
- Activity (Main)
- Activity_Predecessor (Reference copy)
Create relationship:
Activity[ActivityID] → Activity_Predecessor[Predecessor]
Single direction.
2) Create Drillthrough Page
- Create new page
- Add Drillthrough filter
- Drag ActivityID into Drillthrough field
Add a Table visual showing:
Activity_Predecessor[ActivityID]
Now:- Click A → shows B & C
- Click C → shows D & E
For Unlimited Levels (Best Practice)
Use Parent-Child DAX Functions:
Path = PATH(Activity[ActivityID], Activity[Predecessor])
Then use:
- PATHITEM()
- PATHCONTAINS()
This handles multi-layer hierarchy properly.
Final Recommendation
- For simple 2–3 level drill → use self-relationship
- For dynamic unlimited hierarchy → use PATH function
Done
=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!Appreciate your Kudos!!
Jaywant Thorat | MCT | Data Analytics Coach
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
#MissionPowerBIBharat
LIVE with Jaywant Thorat
3 Replies
- Jaywant-Thorat
Super User
Hi Jidapa18
Yes. This is a Parent -> Child (Recursive) Drillthrough scenario.
You have:
- ActivityID
- Predecessor (which is also an ActivityID)
You want:
- A → B, C
- C → D, E
- (multi-level drill)
Solution:
1) Create a Self Relationship TableDuplicate the table in Power Query:
- Activity (Main)
- Activity_Predecessor (Reference copy)
Create relationship:
Activity[ActivityID] → Activity_Predecessor[Predecessor]
Single direction.
2) Create Drillthrough Page
- Create new page
- Add Drillthrough filter
- Drag ActivityID into Drillthrough field
Add a Table visual showing:
Activity_Predecessor[ActivityID]
Now:- Click A → shows B & C
- Click C → shows D & E
For Unlimited Levels (Best Practice)
Use Parent-Child DAX Functions:
Path = PATH(Activity[ActivityID], Activity[Predecessor])
Then use:
- PATHITEM()
- PATHCONTAINS()
This handles multi-layer hierarchy properly.
Final Recommendation
- For simple 2–3 level drill → use self-relationship
- For dynamic unlimited hierarchy → use PATH function
Done
=================================================================
Did I answer your question? Mark my post as a solution! This will help others on the forum!Appreciate your Kudos!!
Jaywant Thorat | MCT | Data Analytics Coach
LinkedIn: https://www.linkedin.com/in/jaywantthorat/
Join #MissionPowerBIBharat: https://tinyurl.com/JoinMissionPowerBIBharat
#MissionPowerBIBharat
LIVE with Jaywant Thorat 
v-echaithraCommunity Support
Hi Jidapa18 ,
Thank you Jidapa18 for your inputs.We’d like to follow up regarding the recent concern. Kindly confirm whether the issue has been resolved, or if further assistance is still required. We are available to support you and are committed to helping you reach a resolution.
Best Regards,
Chaithra E.- v-echaithra
Hi Jidapa18 ,
May I ask if you have resolved this issue? Please let us know if you have any further issues, we are happy to help.
Thank you.