Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Only Apply Filter to Highest Level?

I have graph data which contains Source IDs and Target IDs. I want to filter the Source IDs by Source Application and show all related targets down to the lowest level where there are no other targets associated with the Source ID. However, some Source and Targets have different Source Applications. Is there a way I can apply the filter to the highest level but still pull in the other associated dependencies (targets) that don't meet the filter criteria - i.e. have a different source application. 

 

Example data (simplified):

Source IDTarget IDSource Application
11112222App A
11114444App A
22223333App A
4444 App B
3333 App C

 

Desired output:

 

Thanks!

Need Help

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    Please consider providing more information. Which visualization are you using? Why is the count below the 2222 classification a 1 instead of a 2?

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly.
    If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum -- China Power BI User Group

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello!

       

      Apologies I made an error in the first visual. The visual I am using is a marketplace visual called Drill Down Graph Pro. The number within the circle is the number of dependencies rather than connections. 2222 only has one dependency which is 3333 and 3333 has 0.
      Corrected desired output: