Forum Discussion
In a table visual using a date field with other measures in table, how to display dates with 0 data
Hi i am bringing in data to later export where the first table is what i'm currently displaying. I have several sellers where i'm trying to show by each seller what activity they had by date, and when there is no data for the given day, to show that as zero. I'm trying to have my end result look like the second table. I've created a date table and created a relationship between date to date field where my seller activity resides. I tried the "show items with no date" using the date field in my seller activity table (also tried bringing in the date field from my created date table) and that didn't work. I tried creating a measure for quantity +0 logic and that didn't work. Can someone please help with what i'm missing to fill in the dates with no activity please
| Name | Date | Quantity |
| Alex | 01.02.23 | 1 |
| Alex | 01.04.23 | 3 |
| Alex | 01.06.23 | 7 |
| Alex | 01.12.23 | 2 |
| Alex | 01.27.23 | 3 |
| Name | Date | Quantity |
| Alex | 01.02.23 | 1 |
| Alex | 01.03.23 | 0 |
| Alex | 01.04.23 | 3 |
| Alex | 01.05.23 | 0 |
| Alex | 01.07.23 | 6 |
| Brian | 01.01.23 | 5 |
| Brian | 01.02.23 | 3 |
| Brian | 01.03.23 | 0 |
| Brian | 01.04.23 | 0 |
| Brian | 01.05.23 | 1 |
- Anonymous3 years ago
Hi Antonio195754 ,
I suspect it has something to do with the model, could you please provide a simple example model?
How to provide sample data in the Power BI Forum
Date Table:
Model:Output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
3 Replies
- Idrissshatila
Super User
Hello Antonio195754 ,
Try the Show Data with no value in Power BI.
check it out https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-show-items-no-data
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Follow me on Linkedin
Vote For my Idea💡- Antonio195754
Helper IV
Yes i did try that. I tried that by just using the date field within the activity table and it didn't change anything. I did associate my calendar table to it, many to one relationship single direction. And that worked, however at some point in the table, the user names just kept repeating themselves with the same user for no reason. So i don't think that is the solution i need unfortunately.
- AnonymousNot applicable
Hi Antonio195754 ,
I suspect it has something to do with the model, could you please provide a simple example model?
How to provide sample data in the Power BI Forum
Date Table:
Model:Output:
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum