Forum Discussion
Force Directed Graph with Retrospective
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
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.
6 Replies
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.
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
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: