Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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):
My regional settings is set to Norwegian/European. So the date should be dd-mm-yyyy, but when creating charts Power BI reads it as mm-dd-yyyy.
Any idea how i can fix this in Power BI? Or do i have to go back to SQL and get it in the correct format there? I had some problems when inputting the data in SQL as datetime and not varchar.
Solved! Go to Solution.
I set this on top in my insert sql query:
SET DATEFORMAT dmy;
now its working as it should 😄
You should be able to set this in the modelling ribbon, date format
like this? It still reads as mm-dd-yyyy.
You could change the locale in option.
Go to options and regional settings and select your choice.
If it still doesnt work after you have changed the format in modelling tab, do an explict conversion in SQL e.g (CONVERT(Varchar, Date, 102).
Regards
Yomi
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 😄
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |