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

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

Thanks for the replies.  Change region to english(united states) but still the same. 
Il take a look at converting in SQL.

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