In a table visual using a date field with other measures in table, how to display dates with 0 data

[Antonio195754]

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

[Anonymous · Accepted solution]

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 Team

If 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

[Idrissshatila]

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]

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.