A A Gardner New Member Jan 23, 2015 #1 I am new to Power Pivot. In my first spreadsheet I have a horizontal slicer for months and it is arranging it alphabetically (with April) coming first. Is there a way to arrange it by the actual sequence of the months. Thanks.
I am new to Power Pivot. In my first spreadsheet I have a horizontal slicer for months and it is arranging it alphabetically (with April) coming first. Is there a way to arrange it by the actual sequence of the months. Thanks.
N NARAYANK991 Excel Ninja Jan 23, 2015 #2 Hi , Does this help ? http://blogs.msdn.com/b/analysisservices/archive/2010/04/21/sorting-month-by-natural-sort-order.aspx Narayan
Hi , Does this help ? http://blogs.msdn.com/b/analysisservices/archive/2010/04/21/sorting-month-by-natural-sort-order.aspx Narayan
A A Gardner New Member Jan 27, 2015 #3 Thanks Narayan. I used your link & another excel blog (link below) learnt from both & then resolved it. My report finally looks presentable now. http://excelunplugged.com/2013/04/1...pivot-table-report-based-on-power-pivot-data/
Thanks Narayan. I used your link & another excel blog (link below) learnt from both & then resolved it. My report finally looks presentable now. http://excelunplugged.com/2013/04/1...pivot-table-report-based-on-power-pivot-data/
