| Sorting Months from PowerPivot models in Excel Filters and Slicers |
| Written by Jen Stirrup |
| Wednesday, 07 September 2011 21:25 |
|
ate Sorting by month requires additional steps for Excel Filters and Slicers, and these will be discussed here. The excellent book entitled 'Practical PowerPivot and DAX Formulas for Excel 2010' by Tennick suggests one method of fixing the issues around the Excel slicer sorting, which involves an IF statements on an existing Month Number column to obtain the Month number, and sort by that. This blog offers an alternative way of dealing with the sorting issues involved with Excel Slicers. Here is a different approach, which is designed to promote re-use by generating a separate Month Number column from the Date Key. Read more... |
Author articles
- Sharepoint and PowerPivot: Connections fail to refresh in SQL Server 2008 Denali CTP3
- SQLUniversity: Introduction to PowerPivot and Mobile Business Intelligence
- Sorting Months from PowerPivot models in Excel Filters and Slicers
- DAX PowerPivot Arbitrary Time Intelligence with Fact tables containing Future Data
- PowerPivot in Denali: User Feedback and the Fourth Golden Rule of Interface Design
Most Popular
- Step by step guide on installing PowerPivot for SharePoint on a single machine
- List of suggested datasets to test PowerPivot
- List of PowerPivot DAX functions with description
- How to install PowerPivot for Excel and list of know issues
- Microsoft Virtual Lab: PowerPivot for Excel 2010 Introduction
- List of PowerPivot DAX functions (short)
- Learning PowerPivot and DAX
- PowerPivot's impact on BI pros?
