Forum Discussion
Custom sorting a slicer does not work
dzhogov I am having a similar issue too. I have created a Data Model for my data and am using a Slicer for Months. But the Months are not being displayed in a monthly sorting manner (Jan, Feb .. Dec). I have tried default sorting, created custom sorts but nothing works. Looks like when using the Data Model, there are issues when using sorting.
gaujla , you shall define sorting order. Add one more column with month numbers and select for Months column Sort By these numbers.
SergeiBaklan Thank you very much Sir! that worked beautifully. I was using the same technique but at the wrong location. I was defining the MONTHNUM in my original Data tab but it wasn't working. Slicer kept on sorting my data using the original date (source data order). But as soon as I created the MONTHNUM column in my Data Model, and used the sort MONTH by MONTHNUM, it worked like magic. Thanks a lot.
Another question, my original Data doesn't have any "blank" rows/column/records, but the Pivot Table/Slicer keeps on thinking there is "blank" data. I have unchecked the various options to hide or not show blank data but isn't working. Any help would be much appreciated.
gaujla , it depends on where do you have such blanks, could you give bit more details?
SergeiBaklan I meant "blank" as a record in appearing in Months, Quarters, or whichever Field I use for my Pivot Table. I don't have any "blank" records/columns/cells/rows in my data. Although the source table is dynamic not static, meaning, my source table is $A:W$ and not $A1:$W1048576
