Assign month numbers sequential for next year data!

[Anonymous]

Hi All,

Please i unable to sort the month and year data based on the month number through sorting.

Iam using the 2019 and 2020 data while assinging the month numbers for both the year January it is coming month number as 1.

Do we have any method to follow that if i assign should get 2020 january month as 13, February 2020 as 14 so on !!

Thanks for your help

[Greg_Deckler]

You want Sequential, https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231?search-action-id=10196...

[tkirilov]

Hi @Anonymous ,

Am I assuming correctly that you are trying to display more than 12 months on the same axis? If that's the case, I normally create a new text column with dates in YYYY/MM format and sorting those in alphabetical order. Hope that helps. 

Best,

Tom

[Anonymous]

no i presenting 14 months data and it is not working that approach. January 2019  as coming as 1 and also January 2020 also coming as 1, which is resulting the presentation of data not coming in sequential order

[v-lili6-msft]

hi  @Anonymous 

Just drag [Year] and [Month] in the visual together, as below, then sort by Year Month asc

and you could also use Sort By column in the power bi desktop.

https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column

https://radacad.com/sort-by-column-in-power-bi

Regards,

Lin