Forum Discussion
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 towards January, 2024, however these are mixed up at the moment.
Visualization settings:
Dates table has been created and set as "Date Table", any clues as to what would be the case?
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
3 Replies
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
RegardsAh!, 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?
Hi AyubZafar
I am not 100% sure that i can be work but you can try this by adding one more step like this but manually is only one time activity that you can do in power query so every time you refresh data automaticaly it will change is data type. but you try this query hope that should work
= Table.TransformColumnTypes(#"Removed Columns",{{"SubmissionDateOnly", type date}}) and reanme the Removed Columns to #'SubmissionDateOnly it should workRegards
