A slicer is not affecting another slicer because of ambiguous relationship

[Billgates]

I have 2 dimension tables D1 and D2 and a Fact table F1. D1 -> F1 (1:*), D2 -> F1 (1:*). I have a slicer from D1 which affects the F1. I have another slicer from D2 which also affects F1. I want the slicer from D2 also gets affected while selecting values from slicer D1, in order to achieve this I establised a relationship between D1 -> D2 (1:*), but it turns out to be ambiguous. I'd appreciate your help in fixing this.

[amitchandak · Accepted solution]

@Billgates , You can use measure from F1 as a visual level filter for dimensions to filter each other. Or create both joins as bi-directional

https://www.youtube.com/watch?v=cyOquvfhzNM

[Billgates]

@amitchandak Thank you very much. It's an eye opener.