Problem with line graph bunching on one side

[cyberblitz]

I have created a line graph but the data points are bunching on one side

The data table behind this graph contains a count measure, the x-axis uses a year-month column from a Calander table linked to the date column in the data table where the count is coming from. The data in the table looks fine but when applied to the graph it looks like this. When I switch the x-axis type to categorical, it looks just the way I expect, but I can't use trend lines nor forecast features using categorical. The issue I believe is that the column I'm using from the calendar table has a text data type and it's screwing it up somehow... Any advice would be appreciated.. Or if you require more info, let me know

[cyberblitz]

The data does not bunch-up at one end in any other graph i have used, only when Continuous is selected does this happen (see above screenshots).

However, after some research, Power Bi is not configured to allow trend lines or forecasting when Categorical is selected. It seems a very much asked for ability for years but has never been added. It has problems understanding text-based values for the x-axis to use effectively for Continuous, unless it interprets the data as date fields

[amitchandak]

@cyberblitz , with too much datapoint at the end I doubt any option to help , User can use visual zoom slider -https://powerbi.microsoft.com/en-us/blog/power-bi-november-2020-feature-summary/#_Toc55467056

[cyberblitz]

@amitchandak Thanks, i have already tried changing it to Categorical and know it works, but i need it to work with Continuous so i can use the trend and forecast tools

[amitchandak]

@cyberblitz , make the axis type as categorical and try