Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
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!
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
Hi @Anonymous
You can try adding a new column:
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?
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
96 | |
81 | |
74 | |
66 |
User | Count |
---|---|
129 | |
106 | |
106 | |
86 | |
72 |