Show data if it's not in another linked table

[Syndicate_Admin]

Hello, good afternoon, I'm new and I need help, I have 3 tables, one of them with the product maintainer and another with daily sales, I need to show in the same table the product maintainer but if it doesn't have a sale, I don't know how to show that in zero.

In the example, it only shows me quantity sold from 1 onwards, if I create a product and it has no sale. does not appear. I'm new. Thank you

[Bipin-Lala]

Hi  @Syndicate_Admin,

I am not completely sure if I understood your question, but it seems like you are unable to show product maintainer data for records that do not have a sale in the same table visual. This is the default functionality of Power BI and this is how it behaves. You can try the following suggestions and see if they work for you - 

• Create the table visual with all the fields required
• Select the table visual and open the Visualizations pane
• Go to the columns bucket and right-click on the Product Maintainer or Sales field
• Select the option "Show items with no data"

• This should display all the data including Product Maintainers with no sales

Most probably this should be the solution to your problem.

Another way is to use a LEFT JOIN between Product Maintainer and Sales, instead of relationships to bring all the data together in one table. This can be done via the merge query in the query editor.

Once the left join is done, display all the required fields from the table via the table visual. It should show all the data, including records with no sales.

Let me know if any of the solution helps!

[Syndicate_Admin]

Thank you, it was the solution and a bit of order of how I presented the data, cheers!