X-Axis labels wrong with trend line

[earlenereid]

I am trying to create a Line Chart with a Trend Line.  However, I can't seem to get the X-Axis data labels to display correctly.

X-Axis Type=Continuous (with trend line but date labels are missing values) 

X-Axis Type=Categorical (trend line disappears)

Any help will be most appreciated!

[v-yuezhe-msft · Accepted solution]

@earlenereid,

What you describe is expected behavior.

In Power BI Desktop, the trend line option is only available in Line chart when you set the X-Axis to “continuous”. And Continuous is the default type for X-Axis and it does not show all values in the x-axis.

Regards,
Lydia

[earlenereid]

Thank you for your reply.  While this may be expected behavior, I can't imagine that many people would consider this as acceptable.  Especially since the labels that are showing are misaligned below the data points.  This makes the trend line functionality virtually useless for my application.

I hope that this functionality will be corrected soon.

Best regards,

Earlene

[DCZA]

I am having the same issue and ended being forced to remove the trendline completely in order to get the correct axis labels for the bars on my clustered column chart. If I have a continuous x-axis type, the June 2018 label shifts to the middle bar which is showing the data for May 2018 (the May 2018 label also shifts left). And the righthand bar has no label (which is showing the June 2018 data). If I change the x-axis type to categorical the axis labels issues are resolved, but I loose the trendline unfortunately.

[Anonymous]

I have the same issue that the continuous date axis does not align with the graph itself, also one month shift.