Forum Discussion
Exploring Social Network graph Usage
Hello All, I am using the Lookupvalue function for the first time. I am trying to find out the values in a way that, I have table as below. Employee Name Supervisor Project Manager D...
Dear Anonymous, Abduvali,
Ok, I'll share with step by step:
- Create 4 new colum:
Path = PATH(Employees[EmployeeName],Employees[ManagerName])
Level 1 = PATHITEM(Employees[Path],1)
Level 2 = PATHITEM(Employees[Path],2)
Level 3 = PATHITEM(Employees[Path],3)
- Create new "Emp Hierarchy" on Level 1. Then get Level 2 and 3 into this Hierarchy.
- Download the Journey Chart. Put "Emp Hierarchy" in "Category Data", Salary in "Measure Data"
- Make sure your Filter Emp with Level 3.
That's it!
If you need some help, don't be hesitate tag my name in your topic. I'll try if i can.
Regards,
ManNVSM.
Anonymous,
LOOKUPVALUE Function is not necessary. It is just used to get the name. You need to construct the table including two columns source and target based on the hierarchy.
Exactly v-chuncz-msft. :heart:
Thats what im trying to do.
I need to get the complete upper level and lower level hierarchy.
Can you please give a hint for that.