Forum Discussion
Need help for Social Network Graph Usage
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.
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
kmclorg v-huizhn-msft Any help.
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...
