Forum Discussion
Date/Time format
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.
Hi, Anonymous
Indeed, sometimes I encounter this situation, I usually solve it like this. You can try to change type with locale.
Best regards
Janey guo
Community Support Team _ Janey
If this post helps, please consider accept as solution to help other members find it more quickly.
3 Replies
Anonymous , 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
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.
Hi, Anonymous
Indeed, sometimes I encounter this situation, I usually solve it like this. You can try to change type with locale.
Best regards
Janey guo
Community Support Team _ Janey
If this post helps, please consider accept as solution to help other members find it more quickly.
