Forum Discussion
Helper ISort order for 2019-2020
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
Super UserIf 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/823601
Helper II 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?
- amitchandak
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.
- VPlorim
I am sorry but I just do not understand how I need to rectify this message to get this to appear how I need.