Visulization of a map of connections

[AlisaLGO]

Hi guys!

I am a relatively new to the Power Bi and I believe I have a pretty tough request. I don't know if that's possible with power BI or not. 

I would like to built a map of connections (as I have drawn). 

I have groups in the 1st column and some values in the 2nd column (units). As the first step, it is neccesary to count units. Simple. 

Then I would like to count the number of all possible matchings of two within each group. For example - group dog: 1) bone-tree, 2) bone-table, 3) tree-table. And then I would like to count similar matching couples for all groups (table in H/I columns). 

My expacted map is something as I drawn. The size of the bubble gives an idea about simple counts and sternth of connection depends on the number of counts of the matching couples within the group (something like "communication tightness"). 

Please let me know if that's possible in power BI and excel. 

[AlexisOlson · Accepted solution]

I tried a bunch of visuals and this is as close as I could get.

Network Navigator:

Force-Directed Graph:

[AlexisOlson · Accepted solution]

I tried a bunch of visuals and this is as close as I could get.

Network Navigator:

Force-Directed Graph:

[AlisaLGO]

Wow! This is what I need. Could you please explain me how did you get this? What is the format of the data? 

[AlexisOlson · Accepted solution]

I formatted the data like this:

Sample file attached.

[Gabriel_Walkman]

How about some custom visual? https://appsource.microsoft.com/en-us/marketplace/apps?product=power-bi-visuals&search=connections&p...

Ie.

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380764?tab=Overview

or

https://appsource.microsoft.com/en-us/product/power-bi-visuals/WA104380989?tab=Overview