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?