Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Or is there a way if a node is clicked on the graph, lookup function will retrieve the values from another table.
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
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
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.
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
Is there really no one who can advise me?
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.
Not only one line but apparently a whole set of connections for a selected person. But if it can get the label for that person correctly it surely is possible to grab this information. Is there any specific formula or command to catch what you click on the graph?
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
User | Count |
---|---|
141 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
123 | |
101 | |
71 | |
61 |