Forum Discussion
andyor
Resolver I
Resolver Idates all converting to American format - urgent help please
All of my dates for every report in my companys workspaces have converted to american date format all of a sudden, meaning all data is showing incorrect. Power BI desktop and service now both think 8...
Martaspg
Advocate I
Advocate IHi, you should check workspace configuration for dates-time, also if your data is coming from Sharepoint or SQL, Azure... what is the culture configuration in the source, maybe there has been an update that have changed this.
Alternatively, in Power Query, for each date column you click on the format (at the top-left) and select "culture", that enables to indicate which is the day, month and year by selecting the country and language (you will be able to select USA and English).
Let me know if you can solve it, if not I will try to send some screenshots.