Until now the pivot charts in Self-service have always been sorted based on the measure. Now you can sort the pivot by dimension as well by clicking on "D" in the top right corner! You can return to measure based sorting by clicking "M". Note that options for ascending/descending ordering are not available when sorted by dimension.