Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.
To avoid the N:M relationship i used a bridgetable as below figure shows.
Hoewever when i can only select from left or right 2 tables. But if i want to show fields from both outer tables i get "Cant determine the relationships between fields" It doesnt matter what i do with bidirectional filtering. I cannot
When i use the many to many i can select from both tables
Can anyone explain why this is happening ?
Regards
Solved! Go to Solution.
I dont want a key field in my visual. Next to that. I think that Bridge Tables should be hidden tables. They are there so i can avoid N:M relationships.
Since it is not working for me i switches to N:M relationships.
Thanks anyways
Issue was cause by a text measure. Thanks for you help.
Issue was cause by a text measure. Thanks for you help.
Hi @RJOttenheim ,
Based on my test, please do not drag the related Key field to visuals:
If you want, you need to use the Key field from the Bridge table , as shown below:
Refer to:
How to Join Many to Many with a Bridge Table in Power BI | Seer Interactive
Looking at Power BI Many to Many
Best Regards,
Eyelyn Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
I dont want a key field in my visual. Next to that. I think that Bridge Tables should be hidden tables. They are there so i can avoid N:M relationships.
Since it is not working for me i switches to N:M relationships.
Thanks anyways
try using single directional and one to many
As i said. Changing directions doesnt work.
Single Directional and one to many is what the picture shows.
Check out the November 2023 Power BI update to learn about new features.
Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!