Forum Discussion

AyubZafar's avatar
AyubZafar
Frequent Visitor
2 years ago
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...
Need Help
  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    2 years ago

    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

     

AyubZafar's avatar
AyubZafar
Frequent Visitor
2 years ago

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?

  • qqqqqwwwweeerrr's avatar
    qqqqqwwwweeerrr
    Solution Sage
    2 years ago

    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 work 

     

    Regards