Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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
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 -
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!
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!
User | Count |
---|---|
120 | |
69 | |
68 | |
57 | |
50 |
User | Count |
---|---|
166 | |
82 | |
68 | |
65 | |
53 |