Display month order

[DeBIe]

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. This is fine for most of my pages, but I would like to change the way of my overview page. As you can see this looks like it's January 2020, but it's January 2021. I would like to achieve 2 things and need your help with that, please.

-I would like to change January to January 2021, just to make clear it's about 2021.

-Then I would like to show January 2021 at the end of the visual. Then I can show trendlines in chronological order.

Thank you for your help. Hope that someone can help me.

[amitchandak · Accepted solution]

@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