Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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!
Solved! Go to Solution.
Hi @Anonymous ,
Modify your relationship directions as below:
Here I made a sample data you can refer to .
@Anonymous ,Make both relations, bidirectional and try
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.
Hi @Anonymous ,
Modify your relationship directions as below:
Here I made a sample data you can refer to .
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |