Filtering "Source" and "Target" in Force Directed Graphs

[Anonymous]

Hello everyone,

I am about to loose all my hairs, so, hope someone could help me out about the problem I explain below 🙂

I have a Forced-Directed Graph in my report and I have a table too. I ranked everything in table and I created a slicer to filter the columns in table and also the nodes in the network graph. My main goal is when I filter the table, I would like to see TOPN value of my records and it works fine, I achieved it. However, besides that I also want to see those filtered N values in the network graph. Since forced-directed graph doesn't let me add measure into Source and Target fields, I can not filter it. I could not achieve to create a column which holds the filtered values. Could you please give me an idea to do it or how could I get filtered data into Forced Directed Graphs?

Cheers,

[v-xuding-msft · Accepted solution]

Hi @Anonymous ,

By my test, you could create colculated column as Source and Target. Then use the visual level filter to implement filter TOPN.

If it still doesn't work, can you please post a dummy file that easier to help?

Best Regards,

Xue Ding

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

you sir/madam, @v-xuding-msft, made my day and thank you! I have just learnt sth new and powerful. I also added a slicer to choose N and connected it to those calculated columns to be able to get desired number of rows. I used TOPN dax function to achieve it btw for those who want to do the same.

Cheers!