Forum Discussion
Sort order for 2019-2020
I have a visual that starts October 2019 and I need to continue to show data into 2020.
The issue that I am having is the sort order on the visual.
It is showing Jan oct nov Dec and I need it to appear as Oct Nov Dec Jan
Any suggestions?
Thank you
Hi VPlorim ,
I'd like to suggest you take a look at the following link to know how to create a custom sort table to achieve custom sort order:
Custom Sorting in Power BIRegards,
Xiaoxin Sheng
5 Replies
If you are showing Month-year . Then please make sure you have sort column YYYYMM and it has been marked as sort column.
format(date,"YYYYMM")
Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
https://community.powerbi.com/t5/Community-Blog/Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners/ba-p/890814
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-trend/ba-p/882970
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p/881739
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601I created the column and tried to sort by that column and I have the following message:
This column cant be sorted by a column that is already sorted, directly or indirectly, by this column.
What can I do in this case?
This happen when you create sort column from the column you try to apply sort
Let us Say I have Date column
Month-Year = format(Date,"MMM-YYYY")
Month -Year Sort = format(Date, "YYYYMM")
Month year can sorth on month year sort but date can not.
Hi VPlorim ,
I'd like to suggest you take a look at the following link to know how to create a custom sort table to achieve custom sort order:
Custom Sorting in Power BIRegards,
Xiaoxin Sheng
