How to reformat date column from MM/DD/YYYY to DD/MM/YYYY

[MYDATASTORY]

Hi,

I have a date column which is displaying in the wrong date order currently showing MM/DD/YYYY (12/01/2020) and I want it to start with (day, month, and the year)  DD/MM/YYYY  ( 01/12/2020).   Please below the dummy data.Thanks in advance

Wrong display:                          Required Display:

Date (MM/DD/YYYY)                 DD/MM/YYYY (Required output)

01/01/2020                                01/01/2020   

03/01/2020                                01/03/2020

10/01/2020                                01/10/2020

11/01/2020                                01/11/2020

12/01/2020                                01/12/2020

[MYDATASTORY]

I have found a video on YouTube, and it does explain the steps.

https://www.youtube.com/watch?v=DWjbd7NPUCM

[Tahreem24]

You can try below two options.

Option 1: use the format formula.

Column= Format(TableName[DateColumn], "DD/MM/YYYY")

Option 2: Select your date column and to format option and set the format from the drop-down list.

[camargos88]

Hi @MYDATASTORY ,

Check this link:

https://radacad.com/flawless-date-conversion-in-power-query

I believe you need to load your dates using locale.

[MYDATASTORY]

Thanks so much for quick response, I have found a video on YouTube 

https://www.youtube.com/watch?v=DWjbd7NPUCM

[amitchandak]

@MYDATASTORY , you need change setting to UK format.

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

You can check if you see some options in format.

[MYDATASTORY · Accepted solution]

Thanks so much for quick response, I have found a video on YouTube 

https://www.youtube.com/watch?v=DWjbd7NPUCM