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

[Anonymous]

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!

[amitchandak]

@Anonymous ,Make both relations, bidirectional  and try

[Anonymous]

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 · Accepted solution]

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!