Relationship between two tables with missing data

[bwhitlock]

Have a question about the relationship between two tables. 

I have a purch order table and a container table. Some purc orders do not have containers attached. 

If I link the two tables together how can I list all of my purch orders even though I do not have a container yet. 

In my grid Im using all the fields from the purch order and 2 fields from container. If there is no container record, the the purch order does not show as well. Id like the po to show with the two container fields being blank. 

does this make sense?

[ebeery · Accepted solution]

@bwhitlock have you tried enabling the "Show items with no data" option? on your purch order field?

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data