Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Sort a Month Year Column

I am trying to sort a column called MOnth Year Num. How can I create a column to sort it? I have a Bar chart that shows the last 3 months. So I want to sort that column so that October 2...
Need Help
Show and Tell
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    3 years ago
    Month and Year = FORMAT([Date], "YYYY") & MONTH('Calendar'[Date])
     
    try this, let me know if it works 🙂 
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Can we get more info on how you're trying to sort it? I can see you've made a sort column.

 

Can you select the sort column from here?

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Thanks, I am looking for sth different, which is to sort a  Month Year Num. Your Solutions is for a fiscal year. 
    I have a Bar chart that shows the last 3 months. So I want to sort that column so that October 2022 comes fast

     



    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Create a Month number + Year column

      Year('Date') & Month(date).

       

      Put this column in the Tooltip part of your visual

      Then in the top right of your visual, sort by that column

      Hope this helps!

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        It has ordered but not correctly...
        2023 Jan comes at the right position but  2022 months are not ordered...