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.
Sorry for the wrong exaplanation Greg_Deckler
You completely got wrong.
I jus need to get the hierarchy, not with those lines.
I have jus shown you how the hierarchy should return whenever i choose a Employee Name
So how do you want that returned? In a table, a list of values?
Greg_Deckler A list of values..