Forum Discussion

Samruddhi_11's avatar
Samruddhi_11
Helper I
4 years ago
Solved

Sort by Month - Year

Hii,   Here is my Month-Year column,     Currently, It is sorted by alphabetic order of month but I want by ascending order of year. For e.g,  September2020, October2020, November2020, Ma...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi Samruddhi_11 

    Change the date format to whole number will better you sort the Month – Year .

    (1)Make sure the Month-Year column is in Date format . If not ,change it to Date format .

    (2)Create a column to return the whole number format for the Month-Year column .

    Year-Month = YEAR('Table'[Date])*100+'Table'[Date].[MonthNo]

    (3)Create a column to return the Text format for the Month-Year column .

    month year = FORMAT('Table'[Date],"MMMM") & YEAR('Table'[Date])

    (4)Select the visual ,and Sort by Year-Month , then choose Sort ascending .

    The final result is as shown :

    I have attached my pbix file , you can refer to it .

     

    Best Regards

    Community Support Team _ Ailsa Tao

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.