Hi Poonam! You can do this by changing the sort of the ID field in dimensions (it won't work if you sort the pill).
Under Dimensions, right-click on the field, Default Properties, then Sort. Choose Descending.
I've attached a workbook showing this. Let me know if you have questions!
Book2.twbx 4.1 KB
change the id to dimension and then do it.
Descending order is working but live connection is not updating filter value to the most current one.
Instead if filter selected value is not available it shows selected id in brackets.
Any idea on how to keep latest filter value selected in filter?
I do not believe that is possible yet although I've seen workarounds for dates. Here's the link to the idea in the community if you want to vote it up and/or explore workarounds: https://community.tableau.com/ideas/1713#comment-10112