locked
Sorting the Slicers RRS feed

  • Question

  • Hi,

    I am using 'Microsoft SQL Server 2008 R2 - PowerPivot for Microsoft Excel 2010' (http://www.microsoft.com/en-in/download/details.aspx?id=7609)

    Considering that below is the sample data (source is excel). Can the sorting present above be done correctly.

    Invoice#

    Bucket

    Paymentmade

    17287

    0-3   days

    Yes

    1213

    4-7   days

    No

    a1212

    8-15   days

    Yes

    12ada

    16-30 days

    Yes

    s1322

    Above   30 days

    No

    I know that the latest version of PowerPivot has solved this issue with the 'Sort by Column' feature. But I am very doubtful that the latest PowerPivot version will work with the SQL server 2008R2 setup that I have. As we are hosting these reports in SharePoint 2010 with SQL server 2008R2.

    Any suggestions/workarounds are greatly appreciated.

    Thanks,

    Kalyan

    Thursday, September 20, 2012 8:31 PM

Answers

  • One of my colleague came up with this smart trick which worked!!!

    Have two digits to the numbers.

    00-03 days

    04-07 days

    08-15 days

    16-30 days

    >30 days

    Thanks,

    Kalyan

    • Marked as answer by Elvis Long Monday, September 24, 2012 1:01 AM
    Friday, September 21, 2012 6:51 PM

All replies

  • Slicers are really a separate Excel feature that works with PowerPivot but is technically not part of the PowerPivot technology.  An update to PowerPivot won't change the slicer behavior.

    Slicers - unfortunately - always sort A-Z.   As such, you must create a prefix to your slicer values.  something like:

    1. 0-3 days

    2. 4-7 days

    4. 8-15 days

    and so on




    Javier Guillen
    http://javierguillen.wordpress.com/

    Thursday, September 20, 2012 8:41 PM
    Answerer
  • An update to PowerPivot won't change the slicer behavior.

    Don't agree with you on above point 

    http://www.powerpivotpro.com/2011/07/powerpivot-v2-ctp3/

    But for v1 it is sad :(

    -Kalyan

    Thursday, September 20, 2012 9:14 PM
  • Kalyan,

    Thanks for correcting me here, this is a feature that indeed works in PowerPivot v2.  I suspect the slicer per se has not changed (it *is* a separate object to the PowerPivot install), but instead the query being sent to PowerPivot now includes an equivalent to an 'order by' clause. 

    In powerpivot v1, the solution I suggest is the only one I know of and one presented in multiple blogs.

    Thanks for pointing this out




    Javier Guillen
    http://javierguillen.wordpress.com/

    Friday, September 21, 2012 2:56 PM
    Answerer
  • One of my colleague came up with this smart trick which worked!!!

    Have two digits to the numbers.

    00-03 days

    04-07 days

    08-15 days

    16-30 days

    >30 days

    Thanks,

    Kalyan

    • Marked as answer by Elvis Long Monday, September 24, 2012 1:01 AM
    Friday, September 21, 2012 6:51 PM