Twitter Updates

    follow me on Twitter

    Wednesday, August 03, 2011

    PowerPivot Nuggets - Part 6 - Sort By Column

    In PowerPivot V1 members in a slicer are sorted in alphabetic order by default. This is fine for product descriptions or customer names. But not for months or weekdays.

    The workaround in v1 was to add a number before the weekday as you can see on the right hand slicer in the above screenshot. It works, but it is - let's say' - a little ugly.

    In PowerPivot V2 we can specify a "Sort By Column".

    And this is the result:

    A small but nice enhancement.

    No comments: