Forum Discussion

matdub40's avatar
matdub40
Helper III
1 year ago
Solved

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

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-ma...
Need Help
  • SamWiseOwl's avatar
    SamWiseOwl
    1 year ago

    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's avatar
matdub40
Helper III
1 year ago

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's avatar
Idrissshatila
Super User
1 year ago

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.