Forum Discussion
Custom datetime column inconsistent formatting
On their own they look fine. Next i'd check the 3 different locale settings and make sure they are consistant:
Set a locale or region for data (Power Query) - Microsoft SupportThank you. The data source is a Dynamics365 dataverse. The report region / locale was correctly set to Australia already however my device was using a "default" setting. I have adjusted this to specifically point to Australia instead and this seems to have fixed the issue.
Such a simple solution! Thank you again Ross for helping talk me through this issue. It is truly appreciated!
On their own they look fine. Next i'd check the 3 different locale settings and make sure they are consistant:
Set a locale or region for data (Power Query) - Microsoft Support
Thank you. The data source is a Dynamics365 dataverse. The report region / locale was correctly set to Australia already however my device was using a "default" setting. I have adjusted this to specifically point to Australia instead and this seems to have fixed the issue.
Such a simple solution! Thank you again Ross for helping talk me through this issue. It is truly appreciated!