Month is not reflecting in my line chart

[Diportee97]

 

 Hello guys,i'm having issues with my months value in my Line Chart x axis,i only have two years in my date function 2024 and 2025...2024 only has November and December as the only months which is right while 2025 has just January and February as months which is also correct 

Now here's the problem,anytime i click on 2024 slicer,it only returns blank instead of November and December data and also 2025 returns January and February data which brings wrong data for each months too,i'm so confused as i do not know what to do

Here's the pbix file for more clarification and help,thanks 

https://drive.google.com/file/d/1NBSz2k6-SnXJ6l9WEtIsMuis8sMIaQ1g/view?usp=drivesdk 

[johnt75 · Accepted solution]

Change the relationship with the date table from Start_Date to StartDateOnly and change the type of StartDateOnly to date, not datetime. The time portion of the Start_Date column is what is causing the problem - it cannot link to a value in the date table because it doesn't exactly match unless the Start_Date happens to be at midnight.