How can I display empty comments in Power BI when filtering orders without comments?

[matdub40]

I have a dwh_d_order_sku table that contains information. And another COMCOM that contains comments.

These two tables are linked by the ORDER_NUMBER field, which is the order number, a many-to-many relationship in both directions:

If I make a table with combined information from both tables, it works fine:

But if I want to filter on an order that has no comment in the COMCOM table, and therefore no order number either, this deletes everything:

I'd like to have this with just the two empty comment fields:

How can I display the comments fields of this table even if there are none in it?

[SamWiseOwl · Accepted solution]

Hi @matdub40 

Have you tried in the Field well choosing show items with no data?

This isn't set to both, the COMCOM filters the order_sku table.

By Default a Left outer join returns all rows from one table and removes blank rows in the second.

Here for example my Region: Yorkshire and Humberside has no matching rows but by choosing show items with no data the row appears.

[matdub40]

Hello,

I just tested it works on a small array only with this, Thanks!

But it doesn't just apply to a specific field? I just tried on another table where I have all my information and I have “The request has exceeded available resources. “..

[Idrissshatila]

hello @matdub40 ,

yes it will exceed the available resources since it's showing a huge amount of data, you need to put some filters to minimize the load.

because you're showing all the combination where's there's also no value for it.