Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
shalinder_verma
New Member

Self join hierarchy Drill through and Measures

I have a data model with 2 tables DimEmployee (Employee information) and FactHours (Employee work time and other measures). DimEmployee has a ManagerID which is also an EmployeeID of the manager of the employee. Therefore, I have implemented PATH function to create hiearchy and traversing. So far so good.

 

In visualization, I have

page 1 - shows list of employees with current month hours and other measures. 

page 2 (hidden) - this is a drill through page using EmployeeID. User can navigate to this page from page 1 by drill through on Employee Name. This shows Employee details - monthly hours, department, Manager Name, etc.

 

Problem statement:

Now I want to create drill through from Manager Name to page 2, so I can see Manager's detail and it's Manager and so on. There are 6 possible levels of hierarchies. But I am not able to acheive this. Do I have to change the data model or is it possible with UI layer itself?

0 REPLIES 0

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.