Scatter chart - two data points not in date order

I have an issue with two data points on my XY scatter chart which are not in date order as shown in Fig.1. In this chart, I am trending the output of a manufacturing process ("Crystallinity", Y-axis) against the date the process took place ("Spray Date", X-axis). A legend is added to denote the batch of raw material used. As you can see, I have two data points with a spray date of 10 April 2022 which is displayed between 17 March 2022 and 18 March 2022 but I don't understand why it's out of sequence.

I've provided the background of my data and the queries used further below. Can anyone point out if I'm missing something obvious or is this a bug?

Fig.1

Background information on data and queries

The settings for the X-axis are set to "Don't summarise" and set by "Spray Date" (instead of "Date Hierarchy") as shown in Fig.2.

The data source is an Excel sheet on a network drive where the data is entered on the date of spraying (i.e. chronological order). I double checked the Excel sheet and there's nothing different about the date format of these entries compared to the rows above/below it. During the import of data to Power BI, I added a couple of queries to transform the data which includes the assignment of the date format for "Spray Date". All queries pertaining to "Spray Date" are shown in Fig.3.

After all queries are complete, I am left with the data shown in Fig.4. The two data points in question are listed in chronological order as per the Excel sheet and nothing looks out of the ordinary for these rows compared to the others. No sorting has been applied to the tabulated data.

Fig.2

Fig.3

Fig.4

ETA: Fix grammar