Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
earlenereid
Frequent Visitor

X-Axis labels wrong with trend line

 

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) 

 

Capture.PNG

X-Axis Type=Categorical (trend line disappears)Capture.PNG

Any help will be most appreciated!

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

4 REPLIES 4
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

@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

 

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

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

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.view1.png

 

Anonymous
Not applicable

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

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.