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.