Why my graph showing future and historic data that I don't even have?

[Tony88]

Hello, 

Hope you all doing well. I have a chart with some data and filtered the last 12 Calendar Months. But it showing future data and also more than 12 months of data.  I could not figure it out and this drive me crazy. Can anybody please tell me what I am doing wrong here?  

Y-Axis - 

Total = AVERAGE(BalanceScoreCard[Assist_Grade]) + [CSAT (Graded)_Mth_New] + [Time Spent (Graded)_Mth_New] +[Net_Grade_Mth_New] + AVERAGE(BalanceScoreCard[df_BalanceScoreCard.KB]) +AVERAGE(BalanceScoreCard[df_BalanceScoreCard.Age]) + AVERAGE(BalanceScoreCard[df_BalanceScoreCard.Idle])

https://drive.google.com/file/d/1huqCnp-YdYumGjQjdsOxNaklYI31a26s/view?usp=share_link

Thank you 

[v-zhangti · Accepted solution]

Hi, @Tony88 

Change X-axis Date format.

Result:

Is this the result you expect?

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.