Forum Discussion
How to Sort Month Year Column. (Text Format)
I have a data I want to Sort Month in Order. In Slicer when selecting any thing other than Current Exception month need to be sorted.
Please help. Thanks in Advance.
3 Replies
Anonymous , You need to have a sort column for that. You have a handle based on time
Format(datevalues([Dynamic X axis] &"-2022"), "mmdd" )
Add additional conditional for other and mark this as sort column https://docs.microsoft.com/en-us/power-bi/desktop-sort-by-column
But my advice would be to explore field parameters for dynamic Axis, Above seem like old method
How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-cHi,
I am not sure how your calendar table looks like, but I tried to create a sample like below.
I suggest creating MonthYear Sort Calculated Column like below and then sort the Month-Year column by it.
please check the below picture and the attached pbix file.
MonthYear Sort CC = ENDOFMONTH('Calendar'[Date])
