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 settings are this format.
PowerBI displays it as DD/M/YYYY in slicers, in visuals, in show data tables, everywhere.
what's up with that / how do I force a global format for dates no matter what it is (slicer, visuals, see records, show data)
4 Replies
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
Anonymous
I did test your suggestion. It is not relevent (as noted the data tables show the data correctly. It's the visual that are using wrong formats
Should also note that your suggestion is not supported in direct query :/
