Forum Discussion

pdolzan's avatar
pdolzan
Frequent Visitor
7 years ago

Exploring Network graph, node information and filtering

Hi,

 

I am building a network graph of people and I have Source (from) and Target (to) column in a table imported from csv. I also have in another table with additional information I would like to show if node will be selected on a graph or in the slicer. 

How can I connect table of edges and table of nodes to retrieve node information? In the source and target, columns are a variation of 150 people. I can't connect two columns with one in a different table.

 

10 Replies

  • pdolzan's avatar
    pdolzan
    Frequent Visitor
    7 years ago

    Or is there a way if a node is clicked on the graph, lookup function will retrieve the values from another table. 

    • pdolzan's avatar
      pdolzan
      Frequent Visitor
      7 years ago

      I did manage to do this

      Born/ Era= LOOKUPVALUE('Thinkers-Grid view'[Born/ Era],'Thinkers-Grid view'[Thinker/ Figure], (SELECTEDVALUE(all_bi[from])))

      how can expand the search so the lookup will also use SELECTEDVALUE(all_bi[to]) and retrive Born/ Era

      • v-juanli-msft's avatar
        v-juanli-msft
        Community Support
        7 years ago

        Hi pdolzan

        Your formula is to say the following meaning, right?

        For example, in the "all_l" table, get the value in column[Born/ Era] from table "Thinkers-Grid view" when 'Thinkers-Grid view'[Thinker/ Figure] has the same values as column "all_l"[from].

         

        Create a calculated column in the table  "all_l"

        Born/ Era = LOOKUPVALUE('Thinkers-Grid view'[Born/ Era],'Thinkers-Grid view'[Thinker/ Figure], (all_bi[from]))

         

        As tested, using selectedvalue in your formula in this way doesn't work, please let me know if my understanding is correct, if not, please give me an example.

         

         

        Best Regards

        Maggie