According to my test, I can correctly sort the X-axis using the Sort by->Date column in the scatter chart like this:
If you can’t sort by the data column, I think you should first go to check if your date column is the “Date” type rather than the “Text” type, because the “Text” type of date can’t be sorted correctly.