1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

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.

submitted by /u/i-love-dregins
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#generative AI for data analysis
#natural language processing for spreadsheets
#rows.com
#big data management in spreadsheets
#conversational data analysis
#Excel compatibility
#real-time data collaboration
#financial modeling with spreadsheets
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#Excel alternatives
#data analysis tools
#data cleaning solutions
#slicer
#pivot table
#months
#sort order
How to sort months in a slicer? (Or format Date in slicer to only be months?)