Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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 😀
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
98 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |