cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MiguelMartinez
Microsoft
Microsoft

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

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.

View solution in original post

3 REPLIES 3
andre
Memorable Member
Memorable Member

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.

 

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

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.

View solution in original post

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

April Update

Check it Out!

Click here to read more about the April 2021 Updates!

MBAS Carousel

Sign up for our May 4th event!

May the fourth be with you, join us online!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.