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 a column called month year that runs from Jan 2010 - Dec 2020
When I create a slicer for it, it sorts as :
Apr 2010
Apr 2011 and so on if it is sorted by month and
Jan 2010
Jan 2011 and so on if sorted by year.
I Would like to know how to sort it as folllows:
Jan 2010
Feb 2010
Mar 2010
....
Dec 2010
Jan 2011
Feb 2011
....
Is there any way this can be done?
Thank You!
Solved! Go to Solution.
@Anonymous
one solution is calculate a new column (year *100 + month num) and sort your month year column by this new column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
this way april 2010 and april 2011 would show as 201004 and 201104 respectively.
thanks it works
You might also be able to change that month/year column into a date column and then it will sort automatically. I did that and it still retained the month/year format (save before you try)
@Anonymous
one solution is calculate a new column (year *100 + month num) and sort your month year column by this new column
https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
this way april 2010 and april 2011 would show as 201004 and 201104 respectively.
@Anonymous It Worked. Thank You!
User | Count |
---|---|
94 | |
80 | |
76 | |
65 | |
60 |
User | Count |
---|---|
108 | |
101 | |
77 | |
63 | |
61 |