The sort order of text data field in filter

[Xclipse]

Hi @Tanu_13

Create the calculated field using ifelse, and use this field for sorting in your visuals and filter controls to display months chronologically, not alphabetically.

Please refer the below community post this might be helpful for you.

Quicksight filter by Month

Hi @Skodati8, to sort the month in chronological order, you’ll need to create a month sort column in the dataset or in the analysis as shown below. After that column is created, go to the Field Wells of the x-axis → select Sort options → Select the month sort column you created to sort by → select aggregation as sum → click Apply. Here’s an example of how to create the month sort column. ifelse({Month} = ‘January’,1, {Month} = ‘February’,2, {Month} = ‘March’,3, {Month} = ‘April’,4, {Month}…