Showing results for 
Search instead for 
Did you mean: 
Not applicable

Create visual with hierarchy comparing parent vs child

I need to create a visual where I can compare the actions of the manager to his staff. I get the data from Active directory but it is not clean enough to create a hierarchy with the PATH() function. What can I do to display on one page the count or sum of actions for the staff and the manager. What complicates it further is that the staff and the managers might not be in the same department. So essentially in the example below I will choose a department and the visual needs to display the users in that department, then show the manager for those group of users and then calculate the actions as per a seperate table. The manager in some cases will not belong to the same department (unlike the example below)





Not applicable

@amitchandak - Thank you I already have the User relationship setup. However if I choose a department then the managers name does not always appear as they are in a seperate department. So I need to identify the manager for that user (from the manager column) and then calculate their actions based on the Users relationship between the two tables. Does that make sense? 


Super User
Super User

@Anonymous , In the above case joining Created by with User of staff Hirerachy, should give you the desired output. You can bring in the Manager and User from staff Hirerachy and sum of rest of the columns from Actions table

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

MPPC 2023 PBI Carousel

Power Platform Conference-Power BI and Fabric Sessions

Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.

Top Solution Authors