How to sort months in a slicer? (Or format Date in slicer to only be months?)
I have a slicer for a pivot table with months (from a PQ where I created a column from date using "Name of Month"). It's showing the months in alphabetical order, instead of month order. In slicer settings, I have sort by order source data selected, and on the PQ table they're custom sorted the way I want, but it's still showing alphabetically on the slicer. What am I doing wrong here?
Another option is to work from the date itself - in other pivot tables, the date (formatted as date in my PQ) will automatically chunk into months, years, etc. Here I can't seem to get that option.
Either solution would work for me, as long as I can eventually have the months in the slicer in the proper order. Thanks in advance.
[link] [comments]
Want to read more?
Check out the full article on the original site