How to change date to a different locale's format

[Anonymous]

Hi PBI forum,

I need to change the date of some fields from the US format of MM/DD/YY to the Australia/NZ format of DD/MM/YY.  I tried to change the format of the dates in the Query Editor using the 'Use Locale' option, but this didn't change anything.  How can I do this?

[Nimai123]

Hello @Anonymous  @Bhoga 

I have tried with the sample file, what you have to do is to first change the format of the date column if working well and good and if not then 

Go in your date settings and apply the below settings.

Updated file.

Regards,

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

[watkinnc]

Table.AddColumn(PriorStep, "NewDate", each Date.From([DateColumn], "en-US"), type date) is the way to do it in US, yours is probably "en-AU".

---Nate

[Anonymous]

Hi @Anonymous 

You can try adding a new column: 

DateFormat = FORMAT(Table1[Date]; "DD/MM/YY")

As long as your Date column is formatted as date it should work fine. 

Br 

Adrian

[Anonymous]

Hi @Anonymous,

Thank you for the response.  This did work in the table visual I have, but it did not work in the slicer.  I added the field as a slicer and the format is text.  How can I have the format in a slicer as DD/MM/YY?

[Bhoga]

Hi @Anonymous

Did you find a way to fix this? I am having the same issue, located in Melbourne, Australia and needed the date format in DD/MM/YYYY.
Thanks