Sort Order issue!!

[Anonymous]

So here is a few pictures related to the issue i am having.

The first picture is the visual issue:

The months go in Alphabetical order instead of chronological. 

Dax measure for rolling column is:

Rolling =

VAR FutureMonth = IF(MONTH(TODAY()) > 6 , MONTH(TODAY())-6 , MONTH(TODAY()) + 6)

VAR FutureYear = IF(MONTH(TODAY()) > 6 , YEAR(TODAY())+1 , YEAR(TODAY()) )

Return

IF('Date Table'[Date] < DATE(YEAR(TODAY()), MONTH(TODAY()), 1) , BLANK () ,

IF('Date Table'[Date]>= DATE(FutureYear, FutureMonth, 1) , "Rest of the Dates" , [month] )

)

below are screenshots of the sort by for each colum in my dates table:

[Anonymous · Accepted solution]

Hi  @Anonymous ,

This error occurs because the value of [Month Year sort] in a [Rolling] column exceeds 1 value, for example, there are 23 "1"s in an "Out of Date" in your visual object, resulting in Power bi don't know which one to use.

You need to find something to order by that has the same granularity as [Rolling], for example: the format of January is 1, and there will be errors in sorting. We can use the combination of Month and Day, so you can sort normally.

This is the content of the same error, I hope it helps you:
https://community.powerbi.com/t5/Desktop/Date-table-can-t-sort-other-columns-by-date-Getting-error/td-p/1092086

https://community.powerbi.com/t5/Desktop/Sort-by-Quarter-not-Working-with-an-Index/td-p/1236234

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Error message when sorting rolling column 

also I have got an order now but im having to show the months twice 

[amitchandak]

@Anonymous , not sure why it is based on today not on date example

Month Year = FORMAT([Date],"mmm")
Month Year sort = if(month([Date]) >6, month([Date])  -6, month([Date]) +6)

and mark as the sort column .

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[Anonymous]

I've added both columns but its still not sorting the matrix 
also this is a selection of the data which is relevant to the table

plus the date table