Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Filter slicer from another slicer using crossfilter direction "Single" - dim to fact table

Hello my friends.

 

My relationship filtering between Dim and Fact is set to "Single".

When I set it to "Both" I can easily filter from one dim table to the other, but I don't want use "Both".

Is there a way to keep using "Single" and when I select something in one slicer to be filtered out the other slicer?

From the example, Shops and Products are my slicers. If I select Shop Name the other slicer to show only the products in that Shop. 

 

Thanks!

Need Help
  • v-kelly-msft's avatar
    v-kelly-msft
    6 years ago

    Hi Anonymous ，

     

    Modify your relationship directions as below:

     

     

    Here I made a sample data you can refer to .

     

    Best Regards,
    Kelly
    Did I answer your question? Mark my post as a solution!

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I tried using "Both" but this is filtering back the other fact table and the results are not correct. My model is using 2 dim tables and 2 fact tables. I want to connect each fact table to each dim table and use it as a filter. Maybe I can duplicate (reference) these dim tables and connect them to the 2 fact tables using "Both". At the moment I don't have any other clue how this can be achieved.

      It is like the example model.

      • v-kelly-msft's avatar
        v-kelly-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ，

         

        Modify your relationship directions as below:

         

         

        Here I made a sample data you can refer to .

         

        Best Regards,
        Kelly
        Did I answer your question? Mark my post as a solution!