Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Hi, I have 2 tables, one with all the fact data for orders from customers and then I have a dimension by customer, the wave and team they are part of, a customer can be part of two teams so the relationshp wouldbe a many to many. I tried using the many to many relationship directly in power BI with cross filtering set to BOTH but it didn't work. Then I tried the old way creating a bridge table with unique IDs from both tables and creating Many to 1 - 1 ToMany relationships with the bridge, but the outcome is the same. I cannot pull fields from my tables.... here are a couple screenshots
If I use a report level filter based on Query 1, then Waves data goes blank, and the other way around, if I select something on waves, then data on Query 1 goes blank.
HI @oscarmqz ,
Can you please share a pbix file for test? It is hard to troubleshoot without any sample data.
Notice: do mask on sensitive data before share.
Regards,
Xiaoxin Sheng
User | Count |
---|---|
87 | |
72 | |
69 | |
64 | |
55 |
User | Count |
---|---|
99 | |
91 | |
80 | |
74 | |
64 |