Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Solved! Go to Solution.
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
Proud to be a Super User!
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)
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.
Thanks it solved my issue.
Regards,
Himanshu
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
Proud to be a Super User!
Thank you !!!
It resolved my issue.
Regards,
Himanshu
Can you please show what actually you mean by "Actual dates". It is not clear to me.
Regards
@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
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |