Sort order for 2019-2020

[VPlorim]

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

[Anonymous · Accepted solution]

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 BI 

Regards,

Xiaoxin Sheng

[amitchandak]

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-wi...
https://community.powerbi.com/t5/Community-Blog/HR-Analytics-Active-Employee-Hire-and-Termination-tr...
https://community.powerbi.com/t5/Community-Blog/Power-BI-Working-with-Non-Standard-Time-Periods/ba-p...
https://community.powerbi.com/t5/Community-Blog/Comparing-Data-Across-Date-Ranges/ba-p/823601

[VPlorim]

I 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.