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

[MiguelMartinez]

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?

[andre]

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.

[AlongTheseLines]

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

[marcorusso · 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.