Reverse the Sort Order for a Performance Point 2010 filter

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!

About AussieBICG

Connect with me here https://au.linkedin.com/in/aussiebicg

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s