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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Solution Supplier
Solution Supplier

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!

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors