Forum Discussion

AlexHolmeset's avatar
AlexHolmeset
Icon for Helper III rankHelper III
8 years ago
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): ...
Need Help
  • AlexHolmeset's avatar
    AlexHolmeset
    8 years ago

    I set this on top in my insert sql query:
    SET DATEFORMAT dmy;

     

    now its working as it should :-D

alexbalazsalex's avatar
alexbalazsalex
Icon for Helper IV rankHelper IV
8 years ago

AlexHolmeset

 

Could you try to re add the slicer or date column to your visualisation after changing your local settings :)

 

Alex.

AlexHolmeset's avatar
AlexHolmeset
Icon for Helper III rankHelper III
8 years ago

I set this on top in my insert sql query:
SET DATEFORMAT dmy;

 

now its working as it should :-D