Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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...
Need Help
  • MFelix's avatar
    MFelix
    4 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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

How do i attach a pbix?