Sort a Pivot Table slicer by another column
I’ve got a relatively simple question compared to some of the other content here:
For a project I’m working on I’ve had to convert from using Power Pivot and a Data Model to normal Tables/Pivot Tables without Power Pivot to accommodate some Mac users in my org. When rebuilding some of the pivot tables and slicers, one of my most used ones is a Fiscal Quarter & Year slicer/column which contains data formatted “FQ1’26”, “FQ2’26”, etc. The result of this is that the slicer orders the entries “FQ1’26”, “FQ1’27”, etc. I have what we can call an index column that is “20261”, “20262”, etc that was used in Power Pivot to sort the Fiscal Quarter & Year column - however I’ve struggled to find a way to replicate the functionality outside of Power Pivot. Is there a way in a normal Table/Slicer to sort the Slicer column by another data column?
[link] [comments]
Want to read more?
Check out the full article on the original site