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.
AnonymousSure buddy.
Hope you can solve it and have fun! Remember Accept Solution :heart:
Regards,
ManNVSM.
Anonymous You been great and i hope you will continue with this.
Sorry to say that the solution you have povided with journey chart by MAQ, i cant use that buddy.
It is not the thing that i am looking for, and i think you know it very well.
Well, I have another thing to do,
I hope you help me with this.
Now if you observe this below image.
Now what i would like to show here is,
I want Pro id as a center point of contact, and CEO, QC, PC, DM, PM will be his childs, and then developers should come under PM as you can see that Developers Man ID's are only having single ID i.e 5(PM)
I did written this dax using lookupvalue,
ProMan Name = LOOKUPVALUE(Table1[ProID],Table1[ID],Table1[ProID])
It given me output as
Here the center one is Pro ID, and the rest are all the Emp ID as child ones.
But how can i get those developers under PM as sub childs.
I hope you will help me with this.
I will be waiting for your reply buddy.
I think its better to change the question name :smileylol:
Dear Anonymous,
I'm back.
Is it your expect?
Btw, please send me your pbix with sample data :)
Regards,
ManNVSM.
Anonymous Yes buddy...
But i think i cant send file through this community.