Forum Discussion
Date Display Formatting issues
my regional settings set to short date - numeric date format. The ONLY acceptable format for all numeric dates being YYYY-MM-DD. The data in the query results is this format. My regional setti...
My data tables are displaying as desired.
However the visuals are not
Anonymous wrote:You can set the data types in Powe Query using the locale you select.
That should work. Just did a quick test and had dates in my locale and then duplicated them and changed to a different locale. Pulls in as they are in the column and just set the format to yyyy-mm-dd.
you could problably change the Regional Settings of the file too. File-->Options and Settings-->Options-->Current File-->Regional Settings