Forum Discussion
Helper IIIHow can I display empty comments in Power BI when filtering orders without comments?
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.
Super UserHi 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.
matdub40Hello,
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.
