Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Tables relationship direction keeps switching

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   ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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's avatar
Anonymous
Not applicable
4 years ago

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's avatar
    Anonymous
    Not applicable
    3 years ago

    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.