cancel
Showing results for
Did you mean:
Frequent Visitor

## 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 10
Frequent Visitor

## Re: Exploring Network graph, node information and filtering

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

Frequent Visitor

## Re: Exploring Network graph, node information and filtering

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

Community Support Team

## Re: Exploring Network graph, node information and filtering

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

Frequent Visitor

## Re: Exploring Network graph, node information and filtering

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.

Frequent Visitor

## Re: Exploring Network graph, node information and filtering

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

Frequent Visitor

## Re: Exploring Network graph, node information and filtering

Is there really no one who can advise me?

Community Support Team

## Re: Exploring Network graph, node information and filtering

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

Community Support Team

## Re: Exploring Network graph, node information and filtering

Hi @pdolzan

What does the question mark mean?

Frequent Visitor

## Re: Exploring Network graph, node information and filtering

point is I would like to show just information of one person, not both. But apparently, this add-in, when a node is selected on a graph, grabs the whole line so I always get both names "from" and "to".

My goal is to retrieve only the name I selected on a graph and show information only for this name.

Announcements

#### Community Highlights

Find out what's new in the Power BI Community!

#### Power Platform Summit North America

Register by September 5 to save \$200

#### Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

#### Watch Sessions On Demand!

Continue your learning in our online communities.

Top Kudoed Authors
Users Online
Currently online: 388 members 3,496 guests
Recent signins: