The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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 solution
screen 1
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:
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. ("Место рабты", "Место учебы", "Место предыдущей работы")
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?
Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!