Forum Discussion
How to sort Year/Month?
I have 24 month in column chart. How to sort from January 2019 to December 2020?
Hi Anonymous ,
Add the date column as tooltip in the visual and make it sorted by the date.
4 Replies
- TomMartensSuper User
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
- AnonymousNot applicable
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 - v-frfei-msftCommunity Support
Hi Anonymous ,
Add the date column as tooltip in the visual and make it sorted by the date.
- AnonymousNot applicable
Hi Kenny,
Please provide demo dataset or .pbix.
Thanks