You would like to reverse the sort order of a particular filter in Performance Point – lets just call it “Year”.
When Performance Point 2010 was released it brought with it new sort and filter features – however these do not extend to Performance Point filters – sob http://blog.gnetgroup.com/bi/2010/12/16/new-sort-and-filter-features-in-performancepoint-2010-dashboard-designer/.
Neat post from SQLChick describing how to create a custom numeric ordering attribute in Analysis Services by simply multiplying the original sort key by -1. Details here … http://www.sqlchick.com/entries/2011/9/30/sorting-descending-in-analysis-services-for-a-date-dimension.html
Happy Performance Point filter sorting!