My Date after import to PBI the date become wrong ?

[Paulyeo11]

Hi All

My PBI File :-

https://www.dropbox.com/s/5leoe9mhecycfa2/SI_CSV_v005.pbix?dl=0

My Raw data is correct :-

After import into PBI , the date become :-

[VijayP · Accepted solution]

@Paulyeo11 

You need to Clean your Data , Because of few blanks in the data , your DateDim is creating long list of dates

[VijayP]

@Paulyeo11

Kindly Share your Kudoes, Just clik on the Like 👍button next to my Replies/Messages Thanks

[Paulyeo11]

Thank you very much I willl look into it

[AnkitKukreja]

Hi @Paulyeo11 

I tried doing some changes in your pbix, but nothing worked. This is quite weird that dates are changing in the data model but seems correct in power query.

I would advice you to go back to your data source and make it a date there. It seems that this is an excel issue, where excel and read different formats but Power BI cannot reference that correctly sometimes. If your data source is excel only then please select your date column and press CTRL+SHIFT+3 that would change it to date.

Please try after that and let me know did it worked?

Thnaks,

Ankit

[Anonymous]

@Paulyeo11 ,

It's just a format issue.

Pleasse select the desired format of AR Invoice date column like below- 

Appreciate your kudos !! Please mark my post as solution if it helps.

[amitchandak]

@Paulyeo11 , This correct. Your format is YY MMM, mean Year (YY) and month

And in one row you do not have the date, That is showing as blank. (Deafult is right)

You case use YYYY MMM format or MMM YYYY format