Forum Discussion
How to show data with zero count in table when filtering date
tonton I added a date dimension in your model and linked it with your sales table on the date. Added a measure (I think called Count) and on the slicer used Date from the date dimension.
As a best practice, you always have a star schema in your model and also must add a date dimension in the model for any date-related calculations.
Check my latest blog post Compare Budgeted Scenarios vs. Actuals I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
tonton table here refers to the tables that contain your data (not the table visual), for example, "Sales" or "Orders" or whatever table name is in your model that contains columns.
yes, i tried using the table (not the visual), but it doesnt work, it just counts the rows, same as my number of sales column. But still the same issue occurs where in, products with ZERO sales do not appear
| Products | Sales Count |
| A | 5 |
| B | 3 |
| D | 1 |
| F | 5 |