Forum Discussion
Relationship between two tables with missing data
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?
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
1 Reply
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