Assign month numbers sequential for next year data!

Question

Hi All,&nbsp;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 !!&nbsp;Thanks for your help&nbsp;&nbsp;

tkirilov · Answer

Hi&nbsp;Anonymous&nbsp;,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.&nbsp;Best,Tom

greg_deckler · Answer

You want Sequential,&nbsp;https://community.powerbi.com/t5/Quick-Measures-Gallery/Sequential/m-p/380231?search-action-id=101966136426&amp;search-result-uid=380231

anonymous · Answer

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

v-lili6-msft · Answer

hi&nbsp;&nbsp;Anonymous&nbsp;
Just drag [Year] and [Month] in the visual together, as below, then sort by Year Month asc

&nbsp;
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
&nbsp;
Regards,
Lin

Forum Discussion

Related content

Sequential Assigned Number

Sequential Order column based on multiple criteria

Sequentially number duplicates

Create 3 digit sequential unique key

Power Query adding sequential columns