Forum Discussion
matdub40
Helper III
Helper IIIHow 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...
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.
SamWiseOwl
Super User
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.