Weird behaviour date field

Hi Kees 

Thanks for the reply from gaurav-lakhotia and zenisekd .

Power BI reads dates according to the date format of the region. Since the month will not exceed 12, Power BI will recognize that 14 and 15 are dates rather than months. However, for 9 and 12, Power BI will automatically read the data according to the date format of your region. If the format of your region is month, day, and year, Power BI will read the date according to the month, day, and year, and then display it according to the "yyyy mmm dd" you set. Zenisekd 's method is to force Power Query to read data in the day, month, and year format. If you can use Power Query, you can try the method proposed by zenisekd. I hope it will work for you.

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.