Filter across multiple columns - for Network Navigator

[ianf123]

Hello,

I am very new to Power BI. Apologies if there is an easy answer to this problem...

I am trying to use Network Navigator to represent dependencies between IT services.

I would like to be able to "Filter" on a service so I can just see the dependencies for a single service.

I would like my screen to show ALL the depencencies for the service, where the service in question appears in the Source or the Target columns of my spreadsheet.

Example Data -

Source        Target

Service1    Service2

Service1    Service3

Service4    Service1

Service5    Service6

Service5    Service7

If I filter on "Service1" in Source, the only entries displayed on the diagram are (obviously) the relationships between Service 1-Service2 and Service1-Service3.

I would like to filter across both Source and Target for "Service1", so that I get all Service1 relationships displayed on the same diagram.

ie as well as the Service 1-Service2 and Service1-Service3 relationships, I would like to see the Service4-Service1 relationship on the diagram. Is there an easy way of achieving this?

Thanks in advance!

[v-cherch-msft · Accepted solution]

Hi @ianf123 

You may create a slicer table and then create a measure to use it in visual level filter.Attached sample file for your reference.

Measure =
IF (
    MAX ( Table1[Source] ) IN VALUES ( Slicer[Slicer] )
        || MAX ( Table1[Target] ) IN VALUES ( Slicer[Slicer] ),
    1
)

Regards,

[v-cherch-msft · Accepted solution]

Hi @ianf123 

You may create a slicer table and then create a measure to use it in visual level filter.Attached sample file for your reference.

Measure =
IF (
    MAX ( Table1[Source] ) IN VALUES ( Slicer[Slicer] )
        || MAX ( Table1[Target] ) IN VALUES ( Slicer[Slicer] ),
    1
)

Regards,

[ianf123]

Many thanks for this - I will try to adapt this to my needs.

[v-cherch-msft · Accepted solution]

Hi @ianf123 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution and welcome to share your own solution. More people will benefit from here. If not, please share more details for us so that we could help further on it.

Regards,