Show 0 for Line chart when no data

[fparker61]

I have a line chart with monthly totals and when there is no data I want the line to be at zero. This isn't a case of blank cells, it is no data at all.
I am able to modify the pivot table settings to show 0 when no data and that works but only when there is another column that has data or if there is data in the last row with intermediate zeros.
In the case below, I want to report on 3 values that all are 0 in Feb-22. If I select other columns that have a value, the 0 is there, if not, it goes away.
Is there another setting I can use to show this? I am using the latest version of Excel.

 

[RoryA]

Try right-clicking the date field and then Field Settings, and on the Layout and Print tab, check the option to show items with no data.

 

[fparker61]

That worked but now I am getting all of 2022. I only want data up to my current date which right now is 2/22. My filter is only for months. It is on a date/time field. Maybe I can change that.