Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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
Solved! Go to 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
thank you so much
Happy to help 🙂
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