Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 .
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
100 | |
78 | |
76 | |
52 |
User | Count |
---|---|
144 | |
109 | |
108 | |
88 | |
61 |