Forum Discussion
Date Setting
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 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!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
5 Replies
- Natarajan_MSuper 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! - ryan_mayuSuper User
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
- danextianSuper User
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.
- v-sgandrathiCommunity Support
Hi AshleeD1234,
Thank you danextian ryan_mayu Natarajan_M for your responses to the query.we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.
Should you have any further questions, feel free to reach out.
Thank you for being a part of the Microsoft Fabric Community Forum! - v-sgandrathiCommunity Support
Hi AshleeD1234,
I wanted to follow up on our previous suggestions regarding the issue. We would love to hear back from you to ensure we can assist you further.
Thank you.