Show (value)+0 where there is no data in a line graph whitin a date range (first day until today)

[ViniciusGM]

Hello guys, 
I hope I find you well

I need a graph to show the values of acesses in a website by time. But I have been asked to show zero where there is no data for the graph to be precise...

The problem is, if I use Sum(values)+0, it will show previous dates and future dates where there is no possibility of having any kind of accesses at all...

The value for this accesses starts on 01/08/2021 and should end in "today"

To better illustrate what i ve'been struggling at:

Basically, I need to filter this central line graph to show values (plus zero where there is no data) in a specific date range and nothing seems to be working.

Thanks in advance.
Vinicius

[davehus · Accepted solution]

Hi @ViniciusGM , Could you try creating a calculated column in your date table like below and add it to your visual to restrict the range?

Change to suit your range and tables.

Date Range = IF(AND('Date Table'[DateKey]>= DATE(2022,01,01),'Date Table'[DateKey]<= TODAY()),1,0)

[ViniciusGM]

Thank you very much! 
It worked perfectly! 😁