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 ...
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

pdolzan's avatar
pdolzan
Frequent Visitor
7 years ago

hi v-juanli-msft

 

Thanks for your help, I appreciate it.

 

My initial request would be to create a relationship between two tables so I can retrieve any information from Thinker and show it on a report when the node on the graph is clicked

Is this kind of relationship even possible? As you did observe Thinkers-Grid view is my information source table for Names (all_bi) connected in the graph.

 

I was trying to find another solution with lookup and I tried your formula and it works but the problem is that in the network graph you have Source (all_bi[from]) and Target ( all_bi[to]) as two separate columns and I don't know how to add also all_bi[to] as a search term for the lookup.

 

 

  • pdolzan's avatar
    pdolzan
    Frequent Visitor
    7 years ago

    Is it possible that if I click on the node of the graph I get both values all_bi[from]) and ( all_bi[to]) because if I use Concate :

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

    I get result as if both columns were selected but I did select Lacan

     

    • pdolzan's avatar
      pdolzan
      Frequent Visitor
      7 years ago

      Is there really no one who can advise me?

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

        Hi pdolzan

        Yes. it is possible to select one column but show values from two columns.

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

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

Column3 = CONCATENATE([Column2],[Column1])

         

        Best Regards

        Maggie