Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi there
I am using power BI and my date setting is in the American one which is MM/DD/YY
For some reason all my colleagues have the correct version here which is the Australian one DD/MM/YY
How would I go about changing this in my reporting?
Thanks
Hi @AshleeD1234 You can adjust your locale settings in Power BI Desktop or modify the data format, as others have suggested. However, if the report shows the wrong culture in the Power BI Service, it follows your browser’s settings, which must be updated directly in the browser.
maybe you can try change data type using locale
https://learn.microsoft.com/en-us/power-query/data-types?wt.mc_id=DP-MVP-5004616
Proud to be a Super User!
Hi @AshleeD1234 , you can go into the data pane -> select the date colum -> format -> choose the MM-dd-YY format
Thanks ,
If you found this helpful, please consider giving it a kudo and marking it as the accepted solution — it goes a long way in helping others facing the same issue.
For more Power BI tips and discussions, let’s connect on LinkedIn:
https://www.linkedin.com/in/natarajan-manivasagan
Cheers!
| User | Count |
|---|---|
| 51 | |
| 40 | |
| 29 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 64 | |
| 57 | |
| 40 | |
| 21 | |
| 19 |