Tables relationship direction keeps switching

[Anonymous]

It's been challenging with tables relationships lately

After I set a relationship between 2 tables with one direction and it's valid, Power BI changes the relationship direction after I save it

Here I have 2 tables, both are the same table but "VIC users" has only one column with only unique values

And as you can see, the relationship is valid

After I save it and close the relationships manager,  it switches the direction 

Like this

Thois happens with different tables not only this, but I'll appriciate it if anyone can help with these tables

[absmila]

Its the same relationship PBI is showing. 

In your first image it goes:

|VIC users | 1..* |VIC owners| 

in your second image it goes:

|VIC owners| *..1 |VIC users|

difference is which table pbi is showing as the first table. The direction has not changes.

[SanketBhagwat]

Hi @Anonymous 

I don't see anything wrong with that.

In your first screenshot as VIC users is your dimension table ,it is filtering your VIC Owners table and the relationship is One to many i.e. from VIC users to VIC Owners.

Same is the case with the second screenshot, VIC Owners is related to VIC users and that is why it is Many to one.

In both the cases, the relationship is not changing, if you first select the dimension table in relationships, then it will act as a filter .i.e. it will act as "One" side in your many to one relationship and the dimension table will act as "Many" in the same relationship.

So don't worry about it.
Hope that will make things clear.

Thanks,
Sanket


If this post helps, then mark it as "Accept as Solution" and give it a thumbs up.

[Anonymous]

Hi Sanket, 

Thanks for your comment,

Actually, there is a big difference, changing direction matters,

I want in one visual all data from "VIC users" and matching from "VIC Owners" like a left join

But with switching the direction, now any data in "VIC users" not in "VIC Owners" doesn't appear visually.

This relationship switching problem causes so many problems in data visualization phase.

Thanks,

Esraa

[Anonymous]

Hi , This is default, Just check that the relationship arrow direction is correct. For you issue in visuals could you check if the Show items with data is checked.