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.

MFelix's avatar
MFelix
Super User
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. 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

     

     

    • MFelix's avatar
      MFelix
      Super User
      4 years ago

      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:

       

       

       

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        4 years ago

        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.