Filter visual based on another visual, different datasets

[jwhitf4770]

I have several visuals on 1 page.    They are related to two different datasets which both have "owner" column.    When I ,click on my bar graph with the name,   I want the the tile summary in the other visual to change based on the owner selected in the bar graph.   Is there a way to dynamically apply a filter to a visual based on a value from another visual?

Thanks,

Justin

[v-piga-msft]

Hi @jwhitf4770,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, please share your data sample and the relationship you created, so that we can help further investigate on it? 

Best Regards,

Cherry

[jwhitf4770]

I have the bridge table built.   How do I apply it to AIM Request Completed?  Unfortunately I didn't design the data.

bridge table

[Seward12533]

Several ways you can handle it check out this simple tutorial I put together. https://1drv.ms/u/s!AuCIkLeqFmlhhJgzLZ6jPcWgLGu3Yw

[Seward12533]

Its all about Filter Context. There are several appraoches.  The simplest but most limited is to change teh Filter Direction on one or both of the relationships to Both.  You can also wrap your measure in a calcualte and specify CROSSFILTER as the filter or just put the other table name.  

Here is a tutorial I put together to help expalin filter context a little more. 

https://1drv.ms/u/s!AuCIkLeqFmlhhJgzLZ6jPcWgLGu3Yw

[jwhitf4770]

Thanks I'm working through the examples.  The tough part is that "owner" is not unique in either table.