cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nfomin
Regular Visitor

Network graph in Power BI

A question about the visual element "Drill Down Network PRO by ZoomCharts". I attached screenshots of my graph of connections on the dataset. In the picture "The desired solution" I drew what I want to get. Please tell me how to get all HIS connections when choosing a specific person from the filter? So that you can see on the graph which people he is connected with at the place of study, place of work, etc. (see "The desired solution"), one-to-many connections are displayed.

The desired solutionThe desired solutionscreen 3.JPGscreen.JPGscreen 1screen 1screen 2.JPG

5 REPLIES 5
v-kelly-msft
Community Support
Community Support

Hi  @nfomin ,

 

Not sure if I understand correctly.

Create a measure similarly as below:

Measure = 
var _tab=CALCULATETABLE(VALUES(jira_sample[Assignee]),'jira_sample'[Reporter] in FILTERS(jira_sample[Reporter]))
Return
IF(MAX('jira_sample'[Assignee]) in _tab,MAX('jira_sample'[Assignee]),BLANK())

And you will see:

vkellymsft_0-1626245204930.pngvkellymsft_1-1626245216434.png

 

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Good afternoon, Kelly.

Thanks for the reply. Attached my Power BI file: https://drive.google.com/file/d/1eSGVavVEg8vIy59t7UVw3X4vVVNCQK5a/view?usp=sharing

 
Created a similar measure Measure. But I wanted to select a person from the filter on the right ("ФИО") and other people who worked together, studied together, etc. were displayed from each vertex of the graph (see Figure №2). That is, if you select a person in the filter, I will immediately understand with whom he studied, worked, etc. ("Место рабты", "Место учебы", "Место предыдущей работы")

 

figure №2.JPG

Hi  @nfomin ,

 

Sorry for the late reply!

The link you shared last time isnt public,could you pls modify it as public and reshare it?

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Hello, Kelly!
Yes, exactly, thank you. Please check, the link should be available now.

https://drive.google.com/drive/folders/1c2FBkiRBS2VKlxY-rJPF1D_9Uzhpc5ZW?usp=sharing

Hi @nfomin ,

 

Sorry for the late reply.

After checking your .pbix file,could you pls advise me how to get the branch I circled in red?Which table contains the field?

vkellymsft_0-1627377238682.png

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!