Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredJoin us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM. Register now.
Can someone tell me how I can sort this column chart to get the dates in order. 2022- April is before 2022- February.
Solved! Go to Solution.
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 😀
I helped you quickly, so please help me with kudos.
Please click the thumbs up and acccept solution buttons. Thank you ! 😎
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.
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 😀
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 76 | |
| 38 | |
| 31 | |
| 27 | |
| 26 |