Forum Discussion

DeBIe's avatar
DeBIe
Post Partisan
5 years ago
Solved

Display month order

Hi All,   Best wishes to all of you!   I changed my filter from "current year" to "Previous 11 months" or "Current month". In this way, I can display data from February 2020 until January 2021. T...
Need Help
  • amitchandak's avatar
    amitchandak
    5 years ago

    DeBIe , That you will easily so in case on month year

     

    Month Year = FORMAT([Date],"mmm-yyyy")
    Month Year sort = FORMAT([Date],"yyyymm")

     

    Sort month year on month year sort

     

    Or create a month sort

    Month = FORMAT([Date],"mmmm")
    Month sort = if(month([date]) > = month(today()), month([Date]), 12+ month([Date]))

     

    Sort month on month sort

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

     

amitchandak's avatar
amitchandak
Super User
5 years ago

DeBIe , That you will easily so in case on month year

 

Month Year = FORMAT([Date],"mmm-yyyy")
Month Year sort = FORMAT([Date],"yyyymm")

 

Sort month year on month year sort

 

Or create a month sort

Month = FORMAT([Date],"mmmm")
Month sort = if(month([date]) > = month(today()), month([Date]), 12+ month([Date]))

 

Sort month on month sort

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