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.
v-chuncz-msft yes. I can add a calculated table and is giving me the perfect values but IN MULTIPLE COLUMNS.
As i mentioned in privious comments, i am trying to use this CALCULATED COLUMN in the visual of SOCIAL NETWORK GRAPH which will take ONLY COLUMN VALUES in the SOURCE FILED.
SO IF I WRITE THIS CALCULATED TABLE ALSO again i need to write the LOOKUPVALUE function which leads me to the same current situation.
Please Help
Anonymous,
LOOKUPVALUE Function is not necessary. It is just used to get the name. You need to construct the table including two columns source and target based on the hierarchy.
Exactly v-chuncz-msft. :heart:
Thats what im trying to do.
I need to get the complete upper level and lower level hierarchy.
Can you please give a hint for that.