Forum Discussion

VPlorim's avatar
VPlorim
Helper I
6 years ago
Solved

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 ...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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

VPlorim's avatar
VPlorim
Helper I
6 years ago

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's avatar
amitchandak
Super User
6 years ago

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's avatar
    VPlorim
    Helper I
    6 years ago

    I am sorry but I just do not understand how I need to rectify this message to get this to appear how I need.