A field containing a date formatted as text in Transform data shows as wrong date in visuals

Hi coejnot ,
Have you tried changing it to a date using locale in Power Query?

Let me know if you have any questions.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos 👍are nice too.
Nathaniel

Hi coejnot 

When I import the same data, I get the correct result,

and my setting is,

If you don't want a date in text format to be automatically converted to Date type, you can change this setting,

Go to File - Options and settings - Options,

https://docs.microsoft.com/en-us/power-query/data-types#automatic-detection-of-column-data-type-and-headers

Best Regards,

Community Support Team _Tang

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