Date Data display

[Anonymous]

Hi everyone.

I have date data like this, (mine is US time setting)

But after i Formatted in new column and drag into chart, it is wierd, my data just until Jun.24 but you see now it has Sep and Nov 🙂

originally it is text type. So I thought that i should change this, so I go to Transform, and change text to Date, and then i got this, (this file is not manual, it is date data by system, not manual so i dont know why some data is error but some is not).

and by the way, I also created an auto calendar, but I dont know why it can not use and map to other tables (but i did map relationship date- date)

it is my calendar, is mmddyyyy, i also set the data Reqdate above is mmddyyy but when i drag this into chart it cant display then i still have to use repdate in table above as date.

 Please kindly help.

Thank a lot in advance

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You need to fix it from the power query.

Please refer to the linked video:

https://www.youtube.com/watch?v=xIs8wlt91Mg

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

[Anonymous · Accepted solution]

thank you so much

[Ritaf1983]

Happy to help 🙂

[Ritaf1983 · Accepted solution]

Hi @Anonymous 
You need to fix it from the power query.

Please refer to the linked video:

https://www.youtube.com/watch?v=xIs8wlt91Mg

If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly