Forum Discussion
Sorting by month in Slicers
Hi, Somehow I am not able to sort my slicer by Months from Jan to Dec. It's sorted in Pivot Table and Chart but in slicer it starts with Apr, Feb, Jan, etc.. I tried to solve it in slicer settings...
Most probably creating the PivotTable you added data to data model (default behaviour).
If so you ma re-create the table without data model; or add one more column with month numbers and in Power Pivot sort months by this column.