Forum Discussion

nfomin's avatar
nfomin
Regular Visitor
5 years ago

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 solutionscreen 1

5 Replies

  • v-kelly-msft's avatar
    v-kelly-msft
    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:

     

     

    Best Regards,
    Kelly

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

    • nfomin's avatar
      nfomin
      Regular Visitor

      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. ("Место рабты", "Место учебы", "Место предыдущей работы")

       

      • v-kelly-msft's avatar
        v-kelly-msft
        Community Support

        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!