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.
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
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.
So what about:
Table 2 = SUMMARIZECOLUMNS(Employees[Supervisor],Employees[Project Manager],Employees[Deliver Manager Name],FILTER(Employees,[Employee Name]="Meeta Jangde"))
How are you trying to actually use this? Is it in some kind of visual or in some other calculation? That is going to drive the solution.
Greg_Deckler Actually, what exactly that i am trying to do is,
I am trying to show the hierarchial employees for the table that i have attached using
Social Network graph and i am trying to refer the sample which is availble here.
https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236
In this sample, there in source name they have used a calculated column with function LOOKUPVALUES, where it is returning the names.
Like wise i would like to show in this visual, for a employee, it should show me the upper hierarchy i.e. project manager, delivery manager and supervisor, and as well as the employees at same level.
is it possible?
if it is please help to try this.
Im really sorry for the wrong lead.
Anonymous,
Follow my above post and drag [Value] to Source: Name.
v-chuncz-msft i tried it but no luck.
Its not working as i am expecting.
Its not reflecting the upper level employees also.
