Need help for Social Network Graph Usage

[Anonymous]

Hello All,

In novembers update theres new visual has came up, Social Network Graph which is quite interesting.

In that they have show how a person is connected to their team.

I have a sample table as below.

Now When i choose a Employee Name from the table using a slicer,

It should show me the Supervisor, Project Manager, and Delivery Manager along with the rest of employees at that choosen employee.

I tried the way they have explained it in the sample from here 
https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236

But no luck.

Any suggestions and help will be very much appreciable.

Thanks,

Mohan V

[v-huizhn-msft]

Hi @Anonymous，

Could you please share a screenshot displaying which column have you put in the field zone and your report? In addition, please share your sample data in table rather than picture, which we can copy and use it directly.

Best Regards,
Angelia

[Anonymous]

@v-huizhn-msft I tried the below dax to get the Manager job title.

ManagerJobTitle = LOOKUPVALUE('Project View'[EmployeeJobTitle],'Project View'[EmployeeID],'Project View'[ManagerID])

When i used this i got the error as table of multiple values are supplied were a single value was expected.

then i tried to use the selectedvalue function as below.

ManagerJobTitle = LOOKUPVALUE('Project View'[EmployeeJobTitle],'Project View'[EmployeeID],SELECTEDVALUE('Project View'[ManagerID]))

the output is null.

then i tried 

ManagerJobTitle = LOOKUPVALUE('Project View'[EmployeeJobTitle],'Project View'[EmployeeID],SELECTEDVALUE('Project View'[Project ID]))

But no luck. still geting null value.

I used this Because I am using a slicer i.e PROJECT ID

In my data for project A---> X is the DM, Y is Pm, Z is Supervisor.

The same X is Supervisr for Project B, Y is DM, X is PM,

Like wise i have data which is like a single person having multiple job roles for different projects.

Can you please help me with this. 

I ll be so thankful to you.     

[kmclorg]

For the Lookup to work, every record in your table needs a unique employee ID.

From your description, it sounds like you are using the same employees in multiple project and with different roles.  So you get around this by creating a unique ID for each employee within each project [ProjectEmployeeID] and a unique Manager ID for each manager on each project [ProjectManagerID]/

Add two new columns to your table:

ProjectEmployeeID = [ProjectID]&[EmployeeID]

ProjectManagerID = [ProjectID]&[ManagerID]

Then you can use the following formula to get the ManagerJobTitle column:

ManagerJobTitle = LOOKUPVALUE(ProjectView[EmployeeJobTitle],ProjectView[ProjectEmployeeID],[ProjectManagerID])

Then you should be able to add your ProjectID slicer to the graphic and it will work nicely.

[Anonymous]

Thanks for the reply @kmclorg.

It worked like a charm.

But my major question is something like as,

If a Employee Name is choosen from slicer.

Then in this visual it should show,

Employee, and along with his fellow team mates. --->  Manager --> Supervisor --> Project Manager -- > Delivery Manager.

Kind of hierarchy that i would like to show with this.

Is it possible with this visual and Dax.

Can you give any possible suggestions.

I ll be soo thankful to you.

Mohan V

[Idoine91]

If I understood correctly, the visualization needs only 1 level of hierarchy to work.

Your table lists the employees with their different levels of managers, I guess, but there's no link between those different managers.

You'll need to create a table with the employee, their title, the DIRECT manager, the manager's title.

The tree starts from the upper level manager down to the employee.

Now if you want to see the project hierarchy, maybe the Network Navigator Chart would be more appropriate...

Hope this helps...

[Anonymous]

@kmclorg @v-huizhn-msft Any help.

[Anonymous]

@v-huizhn-msft Thanks for the reply.

Here is the table that i am referring.

Employee Name	Supervisor	Project Manager	Delivery Manager Name
Meeta Jangde	Venkat Reddy	Manoj Mone	Mandar Marulkar
Prashant Pandey	Venkat Reddy	Manoj Mone	Mandar Marulkar
Abhijeet Behare	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Abhijeet Behare	Venkat Reddy	Manoj Mone	Mandar Marulkar
Prithviraj Sawant	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Maulik Patil	Venkat Reddy	Vijay Venkatachalam	Manoj Mone
Mohan Vankudoth	Venkat Reddy	Manoj Mone	Mandar Marulkar
Supriya Dhekale	Venkat Reddy	Manoj Mone	Mandar Marulkar
SHRADDHA NALKAR	Venkat Reddy	Manoj Mone	Mandar Marulkar
Radhika Mantri	Venkat Reddy	Manoj Mone	Mandar Marulkar