Line chart year issue

[RickU]

I'm hoping someone can help me with this line chart. Since I added 2025 Data, the line is not continuous 

let me know if you can help.

[MichaelSamiotis · Accepted solution]

Wow, this is really interesting now. I got confused at first looking at that as I though that this must have been a DAX issue, that you arechanging the data context through DAX. But then I realised that we can try the following:
1) Set the X-Axis to Continuous
2) Make sure your Date column data type is Date and not text. This step should be done before step #1.
3) If you are not using a distinct dim_date_table, I would create one and connect it to the fact table.

I hope this helps. 😊

All the best,

Michael

[RickU]

so the X Axis was set to continuous and I changed it to categorical and bingo... 

I did have the turn off the labels as they were a bit ugly, but I can use this. Thanks!