Filtering other visuals by related group fields

[akilaputa]

Hi

I wasn't sure if this was something that's possible in Power BI, but is there a way to filter by a related group field?

As an example, say I have a dataset on cars, with characteristics on colour and factory location.

e.g.

car A, red, Beijing

car B, red, Tokyo

car C, blue, Tokyo

car D, blue, Beijing

I would like, when car A is selected (either in a filter or a related visual), for the colour related chart to only show red cars (car A and car B), and for the factory location chart to only show cars made in Beijing (car A and car D). This is something we would like to do from a peer comparison point of view across multiple dimensions, but am struggling to find a way to do so using DAX. Any pointers would be greatly appreciated!! 

[v-yulgu-msft · Accepted solution]

Hi @akilaputa,

You should duplicate the source table first. Make sure these two tables are unrelated. 

Add field [Car] from the duplicated table (in my test, it's 'Sample Table (2)') into slicer.

Create below measures. 

color related =
IF (
    SELECTEDVALUE ( 'Sample Table'[Color] )
        = SELECTEDVALUE ( 'Sample Table (2)'[Color] ),
    1,
    0
)

location related =
IF (
    SELECTEDVALUE ( 'Sample Table'[Location] )
        = SELECTEDVALUE ( 'Sample Table (2)'[Location] ),
    1,
    0
)

Add measures into visual level filter.

Best regards,

Yuliana Gu