Forum Discussion
Relationship maps help
Hi all,
I'm completely new to PowerBI. My boss wanted me to create a visual relationship map between the members of our team and who they talk to. I have all the base data available, but I'm struggling with using the tool to present the data. So far, the closest thing that resembles what I want appears to be the Force-Directed Graph, however it may not be the best option for me yet (as I haven't seen anything more suitable).
Sorry for the eye-sore, but for the purposes of privacy, I must blur the names out but I'm hoping it will still give an idea of what I want to achieve.
This mapping is somewhat fine, as that's driven by the data. However, is there a way to:
1. Get the graph to stop jiggling whenever I touch it (I already have "Animations" turned off, yet it still seems to jiggle if I so much as click on a node).
2. Is there a way to create tooltips or a separate section on the screen such that if I were to click on any of the nodes, it will allow me to show certain data fields that I have in my database (e.g. position title, email, and other metadata)?
Cheers all!
An ideal answer I was looking for would be something along the lines of "Network Navigator", which appears to have been taken away from the catalog. Credit to my colleague that somehow stumbled upon that and sent me a template.
10 Replies
An ideal answer I was looking for would be something along the lines of "Network Navigator", which appears to have been taken away from the catalog. Credit to my colleague that somehow stumbled upon that and sent me a template.
st87 You could try Decomposition Tree visual to show the hierarchy and with the help of Tooltip option OR Tooltip Page you could show extra information.
https://learn.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-decomposition-tree
Hi st87 ,
Thank you for reaching out to Microsoft community support
Unfortunately, it is not possible to manually nail down each node in Force Directed Graph. We are only able to change the charge to make the determination.
It is not possible to stop the jiggle of the visuals as they are currently designed.
As Tahreem24 mentioned go ahead and use decomposition Tree if that meets your need
Also try checking out Social Network graph, this seems to have the features that you were looking for in your second part of the question.
Please consider Accepting the solution if the provided answer meets your requirement so as to help other users or get back to us if you have further queries.
Thanks and RegardsHi v-nmadadi-msft ,
Yes the social network tree is structurally the closest I want to what I need, but I don't have pictures (nor want icons). I want to see names, and I don't want to generate an icon with everyone's names for hundreds of people moving forward.
How do you get it so that it will display what's on the example? I created a database with three tables:
1. Table that lists all my team members
2. Table that lists all the stakeholders we have
3. Table that maps which team members talk to which stakeholders.
Basically like this:
Who do I put in as Parent ID, Id, Measure and Values?
In my scenario, I would have team members talking to the same people, so I think this is why when I tried using the decomp tree (my first thought), it didn't seem to work at all.
That view is from the sample pbix downloadable from the custom viz page
https://appsource.microsoft.com/en-in/product/power-bi-visuals/WA104381236?tab=Overview
Hi st87 ,
We have not heard back from you if any of the answers has met your requirement kindly Accept it as the solution to help out other community members or get back to us with any other questions.
Thank youHi st87
May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.
Thank you.
