HI Team

I Have created a Line chart for AR balance & Collection for FY 2023-24 monthly basis, but AR amount to be consider as Running total in order to get the closing balance for the month.

If i put date filter and restricted only FY 23-24, AR will show only the Current year transactions which is not right because only running balnace (OB from Previous year to be added to the current year data to give the right closing balance) can give the proper closing balnce and if i not it will show the all the month data, at least in pivot we have an option to hide these months hence no issue but in chart there is not option to hide the data.

What is the solutions ?