Forum Discussion
Sort Date Selection Slicer
UncleLewis when you click the 3 dots on the slicer, you should be able to choose which field, as well as ascending and descending. The field you choose will sort by the custom index you have set using the 'sort by column' button. Make sure you do that for your Year column too if you want a custom order for years as well as quarters.
Thanks AllisonKennedy ,
That is perfect!
I have a 10 year calendar
I listed all 10 years in a table and added and Index for the Sort Order I want
I then created a table for quarters (Q1'24,,,) and added an Index for that Sort Order
I added both "Sort Tables" my merging to my calendar table
I then sorted the calendar for year and quarter by the appropriate index
Now I have a slicer with 2024 at the top and 2025 (future years) at the bottom
Perfect!
Thanks,
-w
Thanks AllisonKennedy ,
That is perfect!
I have a 10 year calendar
I listed all 10 years in a table and added and Index for the Sort Order I want
I then created a table for quarters (Q1'24,,,) and added an Index for that Sort Order
I added both "Sort Tables" my merging to my calendar table
I then sorted the calendar for year and quarter by the appropriate index
Now I have a slicer with 2024 at the top and 2025 (future years) at the bottom
Perfect!
Thanks,
-w
UncleLewis You're very welcome. Thanks for updating us with the detailed steps for the solution. Can you mark the post as solved so others can easily reference it who might have similar issues? (Feel free to mark your post as the solution, or mark both posts as the solution).
Thanks!