Order week, month and year in correct order

[Anonymous]

Hi everyone, 

I have a graph with on the x-axis the colum Week and the column Month and year. Due to the fact that some weeks will fall in two months (for example week 48 is the end of November and the start of December). 
As you can see in the image below, I have an issue. I have the option to sort it ascending or descending, but due to the new year, I am not able to get it in the right order. How can I solve this? 

[amitchandak]

@Anonymous , make sure month year has sort column

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

[Anonymous]

Hi @amitchandak , 

Thanks for your reply 🙂

It is sorted in the right order. When I remove the column week, I get this results. And that is correct. It is just that I can't filter on month and year first, and then filter on week... 

[amitchandak]

@Anonymous , Not sure what format you need.

But add month year and week on axis.

Concatenate label - off

sort on month year and week (sometime, it shows the Concatenate label = off, even when it is on, then repeat step)

You should get something like this in screenshot

[Anonymous]

@amitchandak thank you. Unfortunately, that is not what I mean. I want it shown per week, including month and year, but due to the start of this new year, it messes up the order. I have made a screenshot and drawn a line how to logical order should be like. 

[amitchandak · Accepted solution]

@Anonymous , Create a new column

Month Week Year = FORMAT([Date],"mmm-yyyy") & format([Weeknum], "00")
Month Week  Year sort = FORMAT([Date],"yyyymm")*100 + [Weeknum]

and Try

[Anonymous]

Thank you very much! The order is restored. The problem was that the date field was using a different methodolgy. So adding  a column with the formula weeknummer and choosing system 1 (https://docs.microsoft.com/nl-nl/dax/weeknum-function-dax) was enough