There are two things to think about. The first is to evaluate the data type of the query item and to confirm whether it is correct. The second is the actual sorting. The approach to the second depends on the correct state of the first.
That list appears as if it is being sorted alphabetically. You might want to confirm that the data type of the query item is what you want, whether the data type is correct given the values (if you have a non-numeric value in the column being used as the source for the query item then the data type ought to be text) and why it is not what you expect.
You can specify sorting on a query item in the properties. In older releases, the property is called sort. You can specify the sort by another query item, the order of the sorting and where to place null values. In newer releases, the property is called members, as it controls both the sorting but the generation of members.
This can be done in the module (which is to be preferred as the sorting is now available to all users of the module) and the dashboard.
Depending on the situation, you will need to decide how to get the query item values to be sorted as you want.
If it is the case that there are non-numeric values in the source column and that they belong there then the data type properly ought to be text. To impose a numeric sorting order to the query item would require that you create a calculation which has a case function looking up the values of the column and assigning a numeric value for each, similar to the following. Alternatively, if you already have a query item where the values are numeric and their order map to the order that you want to sort your query item then you could use that as the sort by property.
Case
When {query item name} = "1" then 1
When {query item name} = "2" then 2
...
When {query item name} = "10" then 10
When {query item name} = "Opening balance" then 617
else
999
end
The 999 is an arbitary high value to handle whatever is not in the case. Depending on your purposes, this could be what you would want or you would want something else. You need to decide where you want the non-numeric values to be positioned in the list and decide on how to assign the sorting values.
The 617 is an arbitary value which is probably greater than any numeric values in your list. This would be if you want that text positioned at the end. If you want it at the beginning you might want to have your expression similar to the following:
Case
When {query item name} = "1" then 2
When {query item name} = "2" then 3
...
When {query item name} = "10" then 11
When {query item name} = "Opening balance" then 1
else
999
end
Here is an example. I have sorted by Month query item by month number. This puts the months into the order that they appear in the calendar, rather than alphabetical order.
------------------------------
IAN HENDERSON
------------------------------
Original Message:
Sent: Mon February 08, 2021 02:41 AM
From: Hashim Raza
Subject: Can we Sort Ascending Filter values in Dashboard
Dear Team - Please see screen shot, of a Dash Board Filter, we need to Sort it in Ascending or Descending. Thanks in advance.
------------------------------
Hashim Raza
------------------------------
#CognosAnalyticswithWatson