March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Register NowGet certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
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?
Solved! Go to Solution.
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?
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
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
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
Check out the November 2024 Power BI update to learn about new features.
User | Count |
---|---|
121 | |
99 | |
90 | |
72 | |
62 |
User | Count |
---|---|
140 | |
121 | |
106 | |
98 | |
94 |