Correct date format in PowerBI

[Anonymous]

Dear All,

I have Activity Submission Date and time field in my dataset. While uploading data in PowerBI then Month is displaying in Date and Date is displaying in month. 

Below is the excel screenshot in which date is showing 12-Jul-2021

But after loading into PowerBI, this date is changing to 07-Dec-2021 which is incorrect. Please help me to correct the date in powerbi. I have tried but not able to do.

Thanks a lot in advance. 

[amitchandak · Accepted solution]

@Anonymous , One option is to have your system format in UK Mode-

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Another is load as text and then split and convert to date

in power query

#datetime(Text.combine({Text.Middle([Column],7,4), " " , Text.Middle([Column],3,2) , Text.Start([Column],2) , Text.End([Column],12)}))

Might have move index by 1 place if needed , like 7 can be 8

[mussaenda · Accepted solution]

Hi @Anonymous,

Try changing your Regional settings to English UK. I assume you are using the English US which affects you date format

File ->  Options and Settings -> Options -> Current File -> Regional Settings

Hope this helps.

[Anonymous]

Dear @mussaenda , @amitchandak - Thanks for your kind help.

I have applied option 1 and it worked. 🙂 I was using Regional Language as  English ( United States) which should be English ( UK) . 

Thanks a lot both of you.

[amitchandak · Accepted solution]

@Anonymous , One option is to have your system format in UK Mode-

https://community.powerbi.com/t5/Desktop/How-to-apply-UK-date-format-dd-mm-yyyy-in-Date-slicer/td-p/599712

Another is load as text and then split and convert to date

in power query

#datetime(Text.combine({Text.Middle([Column],7,4), " " , Text.Middle([Column],3,2) , Text.Start([Column],2) , Text.End([Column],12)}))

Might have move index by 1 place if needed , like 7 can be 8