Forum Discussion
Solved
Change date format?
SQL store the dates as yyyy-dd-mm(collumn is string and not datetime): Power BI shows the date as mm-dd-yyyy(i have for testing coppied the data to excell and set the collumn as date format): ...
I set this on top in my insert sql query:
SET DATEFORMAT dmy;now its working as it should :-D
Thanks for the replies. Change region to english(united states) but still the same.
Il take a look at converting in SQL.
Could you try to re add the slicer or date column to your visualisation after changing your local settings :)
Alex.
I set this on top in my insert sql query:
SET DATEFORMAT dmy;now its working as it should :-D