Forum Discussion
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. 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.
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
1 Reply
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