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.
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!
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 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |