In a filter pane I have a list of 'Team'.
each team has an associate dimension 'Win Year'.
Now in the filter pane, I want sorting for the recent 'Win Year'..
How could be a function ?
you can use the below calculated dimension:
Aggr( Only(Team), ([Win Year], (NUMERIC), (DESCENDING)))
Aggr( Only(Team), (Team, (=Max([Win Year]), DESC )))
try this on the sorting expression (check just the expression):
=Max([Win Year]) //with descending
What about sort numerically?
Click the dimension or measure name (in your case, year) to open the settings and click the sorting button to switch to Custom sorting. Then select sort numerically. The sorting is either Ascending or Descending.
Retrieving data ...