The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
User | Count |
---|---|
12 | |
8 | |
6 | |
6 | |
6 |
User | Count |
---|---|
24 | |
14 | |
13 | |
9 | |
7 |