Drill Through Page Multi Layer

[Jidapa18]

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.

[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.

[v-echaithra]

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.

[Jaywant-Thorat · Accepted solution]

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 Table

Duplicate 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