Manage relationships + How do I add a measures from different tables into 1 visualisation

[Anonymous]

I have 5 tables in total that are all similar
- 2 of the table are the exact same but 1 has data that goes back a 1 day and the other has data that goes back 3 days.
- The other 3 tables are also very similar, with 2/3 columns that are different

In my dashboard the outputs in my visualisations are based on the ‘item’ and ‘item code’ columns (which are in all the tables).

How do I (what option is best) manage the relationship of these tables so that I can use columns from different tables in the same visualisation. So far it seems, powerBI has done it automatically but I don’t really understand.

*I tried to add a measure from table B into a visualisation that has data from table A and that messed up all the number (these are the tables that are the same but go back different days)

FYI - I can’t make these all into 1 big table, the tables are coming from somewhere else

Thank you. 

[Anonymous]

I'm not sure how the tables are related effectively if they are the same tables. depending on the information stored in them it may lead to a less than desirable relationship which will inhibit your end goal regardless of powerBI trying its best to determine the relationship automatically.

RE not being able to make them into 1 big table - Is this because you are not importing / transforming the data which would stop you from appending them into a table where you could implement structure? If they are being brought through using the import method and this just hasn't been explored I would recommend looking at appending them appropriately.

The only effective way I see this being done would be to have individual visualisations for the each table as the relationships, to me, don't seem to be effective given some of the data appears to be redundant.

[Anonymous · Accepted solution]

Thank you. To update, I did just switched the 'relashionships' around which seems to have worked 

[amitchandak]

@Anonymous , if you want to a column from a table and measure from different tables. Then that table should be common/master/dimension table. You will not be able to switch the fact columns with other fact measures.

If you switch complete visual from one fact to another use bookmarks

[Anonymous]

Thank you, I think I need to read up a bit more on table relashionships