Forum Discussion
Custom sorting a slicer does not work
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
gs_aujla , if your source table is till end of the sheet you shall have blank rows. However, with correct aggregation PivotTable shall ignore them. Try to select all rows within the range after last row with data, Home->Clear->Clear All, after that Save file and refresh your PivotTable.
As for the slicer you may in slicer setting Hide items with no data.
SergeiBaklan "blanks" as a field is appearing in the Pivot Table options. It appears on all Column Headings. I don't have any blank rows of data or blank columns in my data. Also, I have a defined table as data source which is supposed to be expandable as time goes on and users make more entries on a daily basis.
