Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.    
Jihwan_Kim's avatar
Jihwan_Kim
Super User
4 years ago

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])
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.