Forum Discussion
Solved
Stacked column chart dates are not sorted
I have a Stacked column chart where dates are not showing in order even tried sorting dates in the chart itself i.e. Sort Axis -> SubmissionDate, dates need to start from December 15th first and then...
Hi AyubZafar
As per the schreenshot, i can see the your date Subbmision Date datatype is not correct. Currently it is taking as categorical vairable instead of date. That should fix your issue if not please share more details.
Did I answer your question? if not please provide more details.Mark my post as a solution! Appreciate your Kudos!!
Check for more intersing solution here: https://www.youtube.com/@letssolveproblem
Regards
Ah!, I pulled date part from datetime column and didn't realized it resulted into a string and not date, using below PQ code:
= Table.AddColumn(#"Removed Columns", "SubmissionDateOnly", each Date.From([SubmissionDate]))
Anyway we can parse it to date here in same line of code instead of manually selecting type?