sorting data by Month-year

[Raju_6952]

Hi,

I have data like below format,

Sep-22

Oct-22

Nov-22

Dec-22

Jan-23

Feb-23

Mar-23

Apr-23

May-23

Jun-23

Jul-23

Aug-23

I tried sort by expression and Used Year*100+Month,But in the chart the sorting is not in the above specified order,Any suggestions to make it works better.

[Or]

Are these actually date fields? Or are they textual? If they're textual, you'll need to first convert them to dates (using e.g. MonthName(date#(YourField,'MMM-YY')).