Forum Discussion
Custom sorting a slicer does not work
Hello all,
For some strange reason, I suddenly cannot sort a slicer using a custom list. I create the list, double click on it with the slicer selected- nothing. I delete the slicer, create the list, create the slicer again- nothing. This used to work fairly recently and I cannot understand what the issue is. Has anyone encountered something similar and how did you fix it?
Regards!
15 Replies
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.
