Blank data when column is in the wrong order

[Anonymous]

I have 2 tables with relationship 1:1 like on a screen below:

Sometimes in t2 there are no records correlated to t1 yet (they will be soon, when it is filled in other frontend program).

Everything is ok when there is correlated data in t2, but when it is not I can't show all data I want in a visualisation.

When correlated data is there my PBI table looks like this (all data in):

But when correlated data is not there I get blanks (for blue data from table2 it is clear as there is no data), but why t1.date is also blank when presented after columns from table2? If it is presented before data from table2 there is no problem.

[mlsx4]

Hi @Anonymous 

I'm not pretty sure, but I think it is related to the way a table works. The order matters because the relationships act like a Left Outer join.  Then, the following values and the number of rows may increase or decrease depending on those relationships and whether the value exists or not in the other table. Since you haven't got items, it cannot "expand" values to reach anything, since t2.status is blank.

I'm not sure if I have made myself clear