How to sort dimension in SAC Story filter

[former_member692525]

Hello,

i am working on a story with dimension filter and i want to sort it . My dimension holds the numeric values 1,2,3,... 12 for 12 months) , when i use this dimension in table or chart , custom sort is possible. however when same dimension i use as filter the values are not sorted. if you have faced similar issue or know how to handle this issue ,please advice. Thank you in advance!

[former_member692525]

The date dimension as shown in the attached screenshot works fine but , then its year dependent and not just period ( jan, feb, mar... dec) independent of year. In my story i want to have a dimension dim1 with values ( jan, feb, mar, apr... dec) and use it as filter. if I use this generic dimension as filter in story, the sort is not working. So i created a dimension dim2 as date but that doesnt solve my problem , as dim2 is always with year and i want to plot a graph with x axis - months( independent of year) and y axis the keyfigure. Year is another dimension in the story also used as filter to show the graph for different year.

is there any other way i can stil have the dim1 ( jan, feb... dec) sorted in the story filter?

Thank you in advance for your support!