cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Power BI Admin
Power BI Admin

How do I know when a relationship is one to many or many to many in the Power BI Designer?

Is there an easy way to know on the Manage Relationships dialog box if the detected or existing relationships are one to many, many to many etc?

Data for Everyone! We mean it
1 ACCEPTED SOLUTION

Accepted Solutions
marcorusso Member
Member

Re: How do I know when a relationship is one to many or many to many in the Power BI Designer?

Go in Manage Relationships, Edit Relationship, Advanced Options, and see "Cross Filter Direction. You do not have "many-to-many", but you enable cross filter in both directions.
3 REPLIES 3
marcorusso Member
Member

Re: How do I know when a relationship is one to many or many to many in the Power BI Designer?

Go in Manage Relationships, Edit Relationship, Advanced Options, and see "Cross Filter Direction. You do not have "many-to-many", but you enable cross filter in both directions.
andre
Advisor

Re: How do I know when a relationship is one to many or many to many in the Power BI Designer?

It’s also worth noting that by default, Cardinality is set to Many-to-One and the Cross Filter Direction is set to Both which actually has caused some issues with some users who don’t understand the difference between “Single” and “Both”.

 

I am wondering if “Single” would have been a better choice.

 

Highlighted
AlongTheseLines Regular Visitor
Regular Visitor

Re: How do I know when a relationship is one to many or many to many in the Power BI Designer?

Yeah, it would be nice to be able to set the default.