How to sort Year/Month?

[Anonymous]

I have 24 month in column chart. How to sort from January 2019 to December 2020?

[v-frfei-msft · Accepted solution]

Hi @Anonymous ,

Add the date column as tooltip in the visual and make it sorted by the date.

[Anonymous]

Hi Kenny,

Please provide demo dataset or .pbix.

Thanks

[Anonymous]

Hi Kenny,

Give a number to month and sort it by month number and go to dataview select month number .

Month Name	Month Number
Jan	1
Feb	2
March	3
April	4

[TomMartens]

Hey @Anonymous ,

please allow me to direct you to this article:

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

As the above article is more general, this section explains how to sort the values of a column "2019/Jan" ... "2020/Dec" by the values of another column: https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column#sort-using-the-sort-by-column-button

Hopefully this provides you with some ideas.

Regards,

Tom