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.
Anonymous I ll be waiting for your reply with thousands of eyes. :smileyhappy:
Dear Anonymous,
After trying many way, I just realize that Social Chart doesn't support the way you want :smileysad:
I'm so sorry because it out of my range, maybe you can think about submit new idea for that Social chart.
The only one "Journey Chart by MAQ" can do it with Hierarchy. You can see the picture below, it can show full (I admit I can not remove the Root node). If you think again and sacrify your beautifull Social chart, then we can discuss this ugly solution.
Hope you can pass this sadness soon!
Sincerely,
ManNVSM.
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 I really thank you for this from my bottom of the heart buddy,
I am impressed. Kudos Kudos Kudos.
Ok...Its sad that it is not possible with that amazing visual.
But as you said we can go with that journy chart my MAQ,
so how we can implement this in that chart.
If you did... can you please share the pbix file.
Great job Anonymous,
Please share in here if you can, I will very interested in your approach to it!!!
Thanks
Anonymous Sure buddy...
You are really awsome..
Really great job..
Will come back once i try it in my report..
Thank a lotttttttttttttt.....:smileyhappy:...
So much of respect.
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.
