Values don't appear when adding from another table

So when I have 'Show Items with no data' checked for my table visual. (If I have this unchecked it works fine, but doesn't display everything we're wanting to see)

 Depending on the order I add data in things don't display correctly.

Here is the data first entered in

If I then add another field from another table that is joined I get this.(which is correct)

But if I do it the other way and add Customer Billing in before Status Reason it does this