Table missing values when Reordered Columns

[vmat]

Hello - I am creating a Table visualizing by picking data from multiple table sources where relationships are defined.

I am doing a left outer join on one table which has data for a customer (Table1) with a Order table (table2) which contains data for most but not all customers. I now want to display the customer and order info in my table view.

When i do this, I face  a very weird issue. When I put customer number (Table1) , followed by orderno (Table2) and then customer name(Table1) - customer name comes as blank.. but if I put customer number (Table1) , followed by customer name(Table1) and then orderno (Table2), then customer name is shown. 

Can anyone explain what wrong am I doing? or what issue is there.

Thanks

[vmat]

Hello - Sure.. please see the attachments. Relationship Model and Tables.

Result Table:

The Customer Name & Country Name is missing for Customers (5000006,5000008,5000009,5000010), even though we have the data in the Customer & Country Tables.

However, if I move the Order# column at the end, Country & Customer Name shows up.

Hope this helps. Thanks!

[Anonymous]

Hi @vmat ,

Based on the description you provided it doesn't seem very good to understand your needs, can you show your relationship model? (model view in Power BI Desktop)
Also, it would be great if you could show a simple sample screenshot to describe your problem.
Please be careful not to include sensitive information in the screenshot information you provide.

Best regards.
Community Support Team_ Caitlyn