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.
Dear Anonymous,
I'm create a new Table 2 = SUMMARIZECOLUMNS(Employees[ManagerID] , Employees[ManagerName], FILTER(Employees, SELECTEDVALUE(Employees[EmployeeName])))
It's base on your above DAX. And you want to show Manager when selected an employee like this?
If my simulation about your problem is correct, I'm sorry I can't help. Because only Measure can refresh data.
Can you tell me more about your expect? Maybe we can find another way to solve it.
Regards,
ManNVSM.
Anonymous
Thanks for asking. I have a debt to pay you. :smileyvery-happy:
This is what i am trying to implement.
By using Social Network Graph, i would like to create organization level span of control for each and every employees.
Why am i going with only this visual is, because we can show lot of info and at the same time it is much ettractive than the other directed and network graph.
So here whenever i choose i person name i should be able to show his complete hierarchy levels.
that is nothing but his direct and indirect connections(till ceo level )
In this https://store.office.com/powerbiaddininstallpage.aspx?rs=en-US&assetid=WA104381236
you can find the sample for that.
Please help me.
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.
Dear Anonymous,
So, your expect is "So here whenever i choose i person name i should be able to show his complete hierarchy levels."
For ex: when click on Emp Name "Jorder", you want this chart show "Paul - Envy - Jorder"? Or something amazing more?
Regards,
ManNVSM.
Anonymous Absolutely. :heart:
Thats exactly what i need to get.
But it should be connected.
Like in this table if you see,
No Name Manager ID
1 A
2 B 1
3 C 2
4 D 3
5 E 3
6 F 4
7 G 6
8 H 6If i choose A...He is at top level because he is not having any manager ID so for him we need to show
the lower level hierarchy that how everyone is connected to each other.
If i choose E... then we need to show his upper level hierarchy ie E connected to C, C connected to B, and B connected to 1
and also his lower hierarchy if present. For E theres no lower hierarchy.
But for F we have the lower and upper hierarchy.
this is what i am trying to implement.
Dear Anonymous,
It's seem i reach your heart (just kidding).
Ok, i have an idea and i need to make some test. I'll be right back.
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.
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.
