Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Syndicate_Admin
Administrator
Administrator

Show data if it's not in another linked table

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.

Agenciacurico_0-1713986737925.png

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

2 REPLIES 2
Bipin-Lala
Super User
Super User

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"

BipinLala_0-1713987748021.png

  • 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!

 




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


Regards,

Bipin Lala | Business Intelligence Developer



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

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.