cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
pdolzan Frequent Visitor
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.

 

image.pngimage.png

10 REPLIES 10
pdolzan Frequent Visitor
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. 

pdolzan Frequent Visitor
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
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].

1.png

 

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]))

2.png

 

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

Re: Exploring Network graph, node information and filtering

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

image.png

 

pdolzan Frequent Visitor
Frequent Visitor

Re: Exploring Network graph, node information and filtering

Is there really no one who can advise me?

Community Support Team
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.

2.png

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
Community Support Team

Re: Exploring Network graph, node information and filtering

Hi @pdolzan

What does the question mark mean?

pdolzan Frequent Visitor
Frequent Visitor

Re: Exploring Network graph, node information and filtering

Hi @v-juanli-msft,

 

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.

 

Helpful resources

Announcements
Community Highlights

Community Highlights

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

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

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.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 388 members 3,496 guests
Please welcome our newest community members: