Forum Discussion
Trouble sorting dates in column chart
Can someone tell me how I can sort this column chart to get the dates in order. 2022- April is before 2022- February.
Create Calenader table with monthname, first date of month
2021 Jan, 01/01/2021
2021 Feb, 01/02/2021
2021 Mar, 01/03/2021
In the Data view, clcik on the monthname, then sort by first date of month
The monthname will then display in the desired sequence
Please click thumbs up and accept as solution buttons. Thanks 😀
3 Replies
Create Calenader table with monthname, first date of month
2021 Jan, 01/01/2021
2021 Feb, 01/02/2021
2021 Mar, 01/03/2021
In the Data view, clcik on the monthname, then sort by first date of month
The monthname will then display in the desired sequence
Please click thumbs up and accept as solution buttons. Thanks 😀
Hi MEFOX
You can follow the solution in this thread: https://community.powerbi.com/t5/Desktop/Sorting-of-Month-Year/m-p/500324
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.I helped you quickly, so please help me with kudos.
Please click the thumbs up and acccept solution buttons. Thank you ! 😎
