How to set up the chart in Looker when the data for dates after today is 0.

[Jeff7]

Hello, I have a question about how to use Looker Studio.
I am trying to visualize data by date from a Google Spreadsheet in Looker.
In the spreadsheet, the dates after today (for example, December 22nd) are listed.
However, the data for the upcoming dates is set to 0. When I set the date range filter to December, the graph shows these 0 values, which is causing an issue.
Is there a way to solve this problem?

[ArkadyZagdan]

Hi! @Jeff7 
Consider replacing zeros with null values as it is what they esentially are until reported.
Meaning just delete values in cells  or update formula.

Another solution would by  setting up a cahrt filer with  to  day range or static one where it always ends today or yesterday.
something like  on this example:

or this one:

Regards
Arkady Zagdan