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.
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,
You may right click [Employee Name] column and select Unpivot Other Columns in Query Editor.