Date/Time format

[Alex_0201]

Hi, struggling to figure out how to change date/time format in PowerBI.

I have bunch excel files that include a column called Time in a following format:

7/5/2021 6:00:00 AM  - mm/dd/yyyy hh:mm (5th of July 2021 6 am)

When imported, no matter what I do, it is converted to 5/7/2021 6:00:00 AM - mm/dd/yyyy hh:mm (7th of May 2021 6 am)

So format kind of stays the same but month and day values are swapped.

[v-janeyg-msft · Accepted solution]

Hi, @Alex_0201 

Indeed, sometimes I encounter this situation, I usually solve it like this. You can try to change type with locale.

Best regards

Janey guo

[amitchandak]

@Alex_0201 , Hope data type is date.

One option column tool, you can choose data format. Once you click you will see that tab.

The second is under Data Modelling you have an option for formatting, you should able to give format you want under property

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-custom-format-strings

[Alex_0201]

Hi @amitchandak  thanks for the comment! tried both, doesn't seem to be working. No matter what format (custom in Model formatting) I choose, dd is confused with mm and other way around.