Line Chart Show empty dates as 0

[jrnunsys]

Hi!

I have a table (a Sharepoint list really) where i manually add each post from my company and I have the following columns:

• Topic (basic idea of the post)
• Content (long text area)
• Date (date published)
• Reach (how many people it reached)
• Likes (how many people liked the post)

Now, with this data i want to create a line chart where I can see the evolution over time of the content's performance. I added Date at the x axis, and I have as values Content in a count format, and Reach as a sum. 

So I get this:

The chart shows the days where content was posted and it's recorded data. 

My problems is that for this visualization I would need to also in the days that I posted no contend a 0 value, but I cant figure out how.

Any work around this?

Thanks

[amitchandak]

@jrnunsys , +0 to the extent you can do that. But this can show all dates.

Try a meausre like

0 entre rango
Medida = var _1= SUM(Opportunity[Opportunity count]) +0
var _min = minx(ALLSELECTED('Calendar'), 'Calendar'[Date])
var _max = maxx(ALLSELECTED('Calendar'), 'Calendar'[Date])
devolución
CALCULATE(if(max('Calendar'[Fecha]) <_min || max('Calendario'[Fecha]) >_max , BLANK(), _1))

[yfquirogah]

I've been looking for the answer to this same problem for quite some time, really glad I found this post, it doesn't solve it completely due to the data I use but it definatly gives me a better idea on how to approach it.

Thank you!

[jrnunsys]

Hi @amitchandak , I am quite a newbie here so I actually can't figure out how to implement that.

Any way you can lay out some steps to follow?

Thanks!

[v-kelly-msft]

Hi  @jrnunsys ,

Can you attach your .pbix file here if there's no confidential information inside?Or could you provide some sample data with expected output?

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!