Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Filtering other visuals by related group fields

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!! 

 

 

Need Help
Tips and Tricks
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous,

     

    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

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi Anonymous,

     

    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