How to Sort Month Year Column. (Text Format)

[Usman640]

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.

[Jihwan_Kim]

Hi,

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])

[Usman640]

Hi Jihwan_Kim,

Thank you for your answer. But the problem is if you look into my 1st Column It has Other values like T6, T5,T4 Etc. I dont have Calendar Table for this.

[amitchandak]

@Usman640 , 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 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

How to Create Sort Column and Solve Related Errors:
https://www.youtube.com/watch?v=KK1zu4MBb-c