Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)
You can set the data types in Powe Query using the locale you select.
@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 😕
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |