Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I have selected to sort axis by month but why is March still showing before the other months? Any help is appreciated.
Solved! Go to Solution.
Hi @ruidi1126
It is necessary to define the sorting method through the data table in order for our visualizations to know how to sort the months chronologically.
In accordance with the month's number.
Please see the attached image.
Here is a link short video explaining how it works:
https://www.youtube.com/watch?v=NvFDasTzP9E
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi @ruidi1126
It is necessary to define the sorting method through the data table in order for our visualizations to know how to sort the months chronologically.
In accordance with the month's number.
Please see the attached image.
Here is a link short video explaining how it works:
https://www.youtube.com/watch?v=NvFDasTzP9E
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Hi,
I followed your instruction but got the following error message. Do you know how to resolve it?
Thanks,
Rui
Hi @ruidi1126 ,
The reason here is, you have alphabetical ordering and the ordering is descending, which means instead of A-B-C it goes othe way around C-B-A. In your case M is then at the beginning.
Change the order in Ascending or even better, create a new column, where you have following logic:
January = 01
February = 02
March = 03
Etc.
Then select your Month column and use Sort By option in the settings of the column and use your new column for sorting by. With this set up, order will not be alphabetical but numerical.
In case you would struggle, let me know and I can provide some printscreens and examples.
Thanks.