Forum Discussion
Assign month numbers sequential for next year data!
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
4 Replies
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
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
