Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Ask questions in Eventhouse and KQL, Eventstream, and Reflex.
User | Count |
---|---|
89 | |
81 | |
65 | |
64 | |
59 |
User | Count |
---|---|
171 | |
115 | |
109 | |
74 | |
69 |