Forum Discussion
Year Sort
I've made a calculated column for Month and year and It's showing as below:
The sorting is not correct it seems. I want the Month and Year to be sorted.
Desired Output
| Deal | Month Year |
| xyz | Jan'2025 |
| xyz | Feb'2025 |
| xyz | Jan'2026 |
| xyz | Feb'2026 |
How can I get the sorting right? Present I've sorted month year by Month.
Below are the formulas I've used:
Hi Anonymous
Create your column as actual dates and then they will sort properly.
Try this to create the column
Month Year = DATE(YEAR(VIEW_FORECASTREVENUE[EXPECTEDINMONTH]), VIEW_FORECASTREVENUE[Month], 1)You should get a column of type DateTime that should sort chronologically
Regards
Phil
Hi Anonymous
You can create a numeric key like 202101 for January 2021 and then use this column for sorting the Month-Year column using the sort by column option.
7 Replies
Hi Anonymous
Create your column as actual dates and then they will sort properly.
Try this to create the column
Month Year = DATE(YEAR(VIEW_FORECASTREVENUE[EXPECTEDINMONTH]), VIEW_FORECASTREVENUE[Month], 1)You should get a column of type DateTime that should sort chronologically
Regards
Phil
Anonymous
Just added an example of how to create the dates based on your data.
Month Year = DATE(YEAR(VIEW_FORECASTREVENUE[EXPECTEDINMONTH]), VIEW_FORECASTREVENUE[Month], 1)Regards
Phil
Hi Anonymous
You can create a numeric key like 202101 for January 2021 and then use this column for sorting the Month-Year column using the sort by column option.HI Anonymous ,
See if this helps
https://community.powerbi.com/t5/Desktop/how-to-sort-Date-MonthYear-column/td-p/102700
https://community.powerbi.com/t5/Desktop/Sorting-of-Month-Year/td-p/500324
Basically you need to create a Index Column and then sort your Month Year Column via the index colum created.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)