Drill down in Dashboard's chart return different values

Summary:

I created a Form for Sales and GP margin for the last 5 years where YearTotal can be drilled down up to monthly Totals. I used this Form in a Dashboard chart but when I drill down the YearTotal for any year (e.g. 2023), the chart shows data coming from year 2020.
How to resolve this issue?

Content (please ensure you mask any confidential information):

Version (include the version you are using, if applicable):

25.10.76

Code Snippet (add any code snippets that support your topic, if applicable):