Power BI datetime format

Question

What is the datetime format in Power BI?

Answer 1

Hello @Maria Kyprianou PowerBI uses the current user locale to format date and time strings. By default, the model culture property (used for formatting) is set according to the user locale of the computer. You can choose from several standard date formats that PowerBI gives you like Short Date, Long Date etc. You may optionally create custom date/time formats as well using the FORMAT function. See here for the list of predefined date/time formats - https://learn.microsoft.com/en-us/dax/format-function-dax#predefined-datetime-formats

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Answer 2

Hello,

Thank you for posting in Q&A forum.

If you want to verify Power BI Desktop default number and date formatting, please refer to

Supported languages and countries/regions for Power BI - Power BI | Microsoft Learn

and in Power BI, we can manually change datetime format as follow:

or use DAX function to change format, here's an example:

Hope this answer can help you well.

Best regards，

Jill Zhou