Forum Discussion
Solved
How to change the date format?
Hi, For Data: I have imported a .CSV file. I have two questions? My Date is in format 1/3/2016 7:56:00 AM (DD/MM/YYYY hh:mm:ss), but PowerBI is reading the Date as MM/DD/YYYY hh:mm:ss. ...
sanchit This is controlled by the Locale Setting!
MM/DD/YYYY is the US format (and maybe some other countires not sure???)
But your csv file likely came form a place where they use DD/MM/YYYY
To have PBI recognize those as dates Go to File => Options and settings => Options => Locale => change to your country/region
Another way of doing:
In Power Query Editor, right-click on the column header / "Change Type" / "Using Locale..." / then choose Date format with the locale you want
source:
https://community.powerbi.com/t5/Desktop/date-format-is-changed-in-power-bi-desktop/m-p/45385#M17618
How do we change only the column header to date format and the data to be in the number format?
Many thanks
Vinay