Dates displayed incorrectly in power bi (30 -Dec- 35 etc)

[Anonymous]

Hi, 

I have an excel file of sales data, with a column for purchase date. 

When i import into power bi, it displays the dates very strangly (20-sep-25, 30-may-37 etc).

Any ideas why this is happening?

Thank you!

Sonia

[v-lili6-msft]

hi, @Anonymous

You could try to change the format of this column

If it is not your case, please share your excel file just with one purchase Date column. You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

Best Regards,

Lin

[Anonymous]

I just noticed too that they're all fine in the Query editor, but not in the main data section 

Thanks again!

[v-lili6-msft · Accepted solution]

hi, @Anonymous

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Best Regards,

Lin