Table blank if Parent selected that has no Child record?

[OneWithQuestion]

I have an Order Header table and Order Line table (one order may have many lines in it).

I have run into an issue where if I display the Order Header in a table and click on it to filter, other tables which have the same column go blank when they do not have child records as well.

I would understand if the 2nd table had only child record columns as no child records exist to display, but I display the Order Header ID along with the Order Line children columns.  Why would it not just show the Order Header ID and the child columns as blank?

The Order ID from the parent table Order Header should still show up right?

I want to see that Order Header row just with blank entries for Order Line columns

[v-cherch-msft]

Hi @OneWithQuestion 

You may select 'Show items with no data' for the visual.Then it will show the blank rows.

Regards,

Cherie

[hjaquez]

It would make sense for this to be the default setting. 

[OneWithQuestion]

I set that, it did not seem to make any difference.

Is there a way I can upload or share the pbix file with you?

[v-cherch-msft]

Hi @OneWithQuestion 

You can upload it to OneDrive and post the link here.

Regards,

Cherie

[OneWithQuestion]

Thanks!

link

[v-cherch-msft · Accepted solution]

Hi @OneWithQuestion 

Order Header Table is filter Order Line table with single direction.So you may not see the MMM... because there's no MMM... in Order Line table.You may have a look at this article about relationship.For your requirement,i would suggest you create two measures and select 'show items with no data' to get it.Attached sample file for your reference.

Measure_OrderID = MAX('Order Line'[Order ID])

Measure_OrderLineID = MAX('Order Line'[Order Line ID])

Regards,

Cherie