Maintain Descending sort order for Unselected values in Filter

[Shubham_A]

Hi,

This is my Fiscal Quarter, after selecting any quarter the unselected values go back to ascending sorting as shown below.

My goal is to ensure that unselected values also maintain the descending sort order. How can I achieve this behavior? Are there any configuration settings or walkarounds that can help me maintain the descending sort order for both selected and unselected values?

I appreciate any insights or suggestions.

Thank you!
Shubham

[cristianj23a]

Hi, try the following code:

Only({1} [our field you want to sort])

I add this code to the order option, here is an image

But before that, create a new field that becomes number to sort, you can do that in the script.

Quarter&Year as NumTrimestreYear

Regarts.

[Shubham_A]

Hi,
I appreciate your prompt response.

However, we are already using the following expression num(date([$(Fiscal Weekend Date)]))& [$(Fiscal Quarter)] to sort this in descending order in the filter pane, but the sorting issue seems to happen is in the top selection pane only

Filterpane

Top Selection Pane