Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to sort Year/Month?

I have 24 month in column chart. How to sort from January 2019 to December 2020?  
Need Help
  • v-frfei-msft's avatar
    v-frfei-msft
    6 years ago

    Hi Anonymous ,

     

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

     

TomMartens's avatar
TomMartens
Super User
6 years ago

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