topic Re: Force Directed Graph with Retrospective in Desktop

Force Directed Graph with Retrospective

Anonymous — Mon, 07 Mar 2022 16:32:28 GMT

Hi there,

In a force directed graph, I'm looking to see all interactions related to a node when a slicer is used.

In the below you could see once Atlanta is selected, it shows only ATL - BOS but not BOS - ATL. Is there a way to show all interaction to that node? apologize i could not attach the pbix however i have provide the details below.

DummyData

Source	Destination	Flight
Atlanta	Boston	Flight1
Atlanta	Chicago	Flight2
Atlanta	NewYork	Flight3
Boston	Atlanta	Flight4

Thanks

Re: Force Directed Graph with Retrospective

MFelix — Wed, 09 Mar 2022 10:56:24 GMT

HI Anonymous ,

Create a table with all the airports then add the following measure:

Filter Airports = IF ( VALUES ( 'Table'[Destination] ) IN VALUES ( Airport[Airport] ) || VALUES ( 'Table'[Source] ) IN VALUES ( Airport[Airport] ), 1 )

Now use this measure to filter out the Force direct and the Airport has your slicer:

Check PBIX file attach.

Re: Force Directed Graph with Retrospective

Anonymous — Wed, 09 Mar 2022 16:34:30 GMT

Thanks Miguel. It works. I have few more scenario.

How do i attach a pbix?

Re: Force Directed Graph with Retrospective

Anonymous — Wed, 09 Mar 2022 17:13:26 GMT

Thanks Miguel. Apologize i cant attach since my org does not allow online drives. So trying my best on the image below. On the same report i have another visual. (i cant use filter airport to the visual. may be its a visual issue?)

Changes made

- Added a new record (phoenix to atlanta record)

- Added phoenix to airport table

- Added State to airport table

- Added Decomposition tree

Re: Force Directed Graph with Retrospective

MFelix — Wed, 09 Mar 2022 18:25:26 GMT

Hi Anonymous ,

To what I can you want to show the routes correct?

Try the following add the measure below:

Total Flights = COUNTROWS(filter(ADDCOLUMNS('Table', "FilterAirports", [Filter Airports]), [FilterAirports] <> BLANK()))

Now use this measure on the tree map visualization and the destinations / source on the explanation:

Re: Force Directed Graph with Retrospective

Anonymous — Wed, 09 Mar 2022 21:11:51 GMT

Thanks Miguel. Almost close. But the below is what im trying to get. Any thoughts. I'm not trying to count the flights.

Please dont get carried away by the word "Destination". The intent of the tree is show only connections between airports and what flights. Atlanta connects 4 airports. So when atlanta is selected, tree's first column should only be 4 airports. Next tree column is flights.

Re: Force Directed Graph with Retrospective

MFelix — Thu, 10 Mar 2022 12:17:35 GMT

Hi Anonymous ,

Since you want to different interactions and with a single slicer you need to make a second table for the airports and the add the following measure:

Filter Decomposition = VAR temp_table = FILTER ( ADDCOLUMNS ( 'Table', "FilterAir", [Filter Airports] ), [FilterAir] <> BLANK () ) VAR airportsselection = UNION ( FILTER ( SELECTCOLUMNS ( temp_table, "Airport", 'Table'[Source] ), NOT ( [Airport] IN VALUES ( 'Airport - Slicer'[Airport] ) ) ), FILTER ( SELECTCOLUMNS ( temp_table, "Airport", 'Table'[Destination] ), NOT ( [Airport] IN VALUES ( 'Airport - Slicer'[Airport] ) ) ) ) RETURN COUNTROWS ( FILTER ( 'Airport - Decomposition Tree', 'Airport - Decomposition Tree'[Airport] IN airportsselection ) )

Now use the column on the second airport table to be you column on the decompostion tree and filter the decompositon by the previous measures: