Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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. 

FilterSlicers_01.png

 

Thanks!

1 ACCEPTED SOLUTION

Hi @Anonymous ,

 

Modify your relationship directions as below:

 

Annotation 2020-03-30 175941.png

 

Here I made a sample data you can refer to .

 

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

View solution in original post

3 REPLIES 3
amitchandak
Super User
Super User

@Anonymous ,Make both relations, bidirectional  and try

Anonymous
Not applicable

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.

image_thumb-14.png

Hi @Anonymous ,

 

Modify your relationship directions as below:

 

Annotation 2020-03-30 175941.png

 

Here I made a sample data you can refer to .

 

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.