Forum Discussion
Wrong date import from excel file
Anonymous - you had similar issue previously and I think this was resolved here- https://community.powerbi.com/t5/Desktop/Inconsistent-Date-Format-in-excel-file/m-p/1447247#M607073
Community ChampionHi Anonymous
A) Is what you show in the pic how the data is shown in Excel (looks like it, since it's text)
B) In what format are the dates you are importing from the Excel? It seems Month/Day/Year (you have 10/19/2020 for instance)
C) In what format do you want the output dates?
All this probably has to do with the regional settings in your pbix (File->Options and Settings->Options->Current File->Regional Settings) and/or you machine locale
Please mark the question solved when done and consider giving a thumbs up if posts are helpful.
Contact me privately for support with any larger-scale BI needs, tutoring, etc.
Cheers