Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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.
Solved! Go to 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 , 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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
87 | |
84 | |
68 | |
64 | |
63 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |