Forum Discussion
Exploring Social Network graph Usage
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.
Not entirely sure how you want to return these, but something along the lines of:
MyLookup = CONCATENATE(
CONCATENATE(
LOOKUPVALUE([Supervisor],[Employee Name],"Meeta Jangde"),
"--->"
), LOOKUPVALUE([Project Manager],[Employee Name],"Meeta Jangde")
)
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..
LaurentCouartou thanks for the reply.
I did try this. but when i use that column in Social network graph( https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236 ) Source name, it returns me only single value.
Any help.
