Drill Through Page Multi Layer

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