cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jessalbea Frequent Visitor
Frequent Visitor

MonthYear field not sorting correctly on Scatter Chart x-axis

Scatter Chart not sorting.PNG 

 

Anyone here had experience on x-axis of scatter chart not sorting? I am using a MonthYear field.
even if I choose the field in Sort by of the visual it still not sorting correctly. please refer to the screenshot.

also note that I choose the same fields in a table and it is sorted correctly

2 REPLIES 2
Community Support Team
Community Support Team

Re: MonthYear field not sorting correctly on Scatter Chart x-axis

Hi @jessalbea,

 

Did you have a full date column? Then just make the Month Year sorted by the date column in Data pane.

 

1.PNG2.PNG

 

Regards,

Frank

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

Re: MonthYear field not sorting correctly on Scatter Chart x-axis

Hi @v-frfei-msft,


thank you for the reply.

 

I am using Azure Analysis Services as my source, and I've already sort the field by the Date column but still won't sort correctly on scatter chart.

 

Capture.PNG