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
Did you have a full date column? Then just make the Month Year sorted by the date column in Data pane.
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.