Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Filter visual based on another visual, different datasets

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

Need Help
Tutorial Requests

5 Replies

  • Seward12533's avatar
    Seward12533
    Solution Sage
    8 years ago

    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi Anonymous,

     

    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