Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Need help for Social Network Graph Usage

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

 

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks
Tutorial Requests

7 Replies

  • v-huizhn-msft's avatar
    v-huizhn-msft
    Microsoft Employee
    8 years ago

    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's avatar
      Anonymous
      Not applicable
      8 years ago

      v-huizhn-msft Thanks for the reply.

       

      Here is the table that i am referring.

       Employee NameSupervisorProject ManagerDelivery Manager Name
      Meeta JangdeVenkat ReddyManoj MoneMandar Marulkar
      Prashant PandeyVenkat ReddyManoj MoneMandar Marulkar
      Abhijeet BehareVenkat ReddyVijay VenkatachalamManoj Mone
      Abhijeet BehareVenkat ReddyManoj MoneMandar Marulkar
      Prithviraj SawantVenkat ReddyVijay VenkatachalamManoj Mone
      Maulik PatilVenkat ReddyVijay VenkatachalamManoj Mone
      Mohan VankudothVenkat ReddyManoj MoneMandar Marulkar
      Supriya DhekaleVenkat ReddyManoj MoneMandar Marulkar
      SHRADDHA NALKARVenkat ReddyManoj MoneMandar Marulkar
      Radhika MantriVenkat ReddyManoj MoneMandar Marulkar

       

       

       

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      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's avatar
        kmclorg
        Helper I
        8 years ago

        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.