+ Reply to Thread
Results 1 to 2 of 2

Can't sort Slicer in order of Month

  1. #1
    Registered User
    Join Date
    03-20-2024
    Location
    Germany
    MS-Off Ver
    16.0.17328.20184
    Posts
    1

    Question Can't sort Slicer in order of Month

    Hi, I have an assignment with a small set of example data in CSV format. I have to build a dashboard for it. Everything works fine except the slicer. In the assignment, it says I have to include a way to only show specific months or quarters. I'm able to add a functional slicer, but I can only sort it alphabetically, not in chronological order. How can I fix this?Dashboard_excelforum.xlsx

    first slide is the dashboard it self.
    second slide is the Dataset i imported from file.
    all after are the pivot tables

  2. #2
    Forum Expert
    Join Date
    10-19-2021
    Location
    Brazil
    MS-Off Ver
    Office 365 V2401 w/ Win10 Home 64 Bit
    Posts
    2,014

    Re: Can't sort Slicer in order of Month

    Possible solution, change name date for date (1/1/2024).
    See file attached.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sort Month Slicer that is Text?
    By NewYears1978 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-05-2023, 01:37 PM
  2. Replies: 4
    Last Post: 04-07-2022, 09:51 AM
  3. Change Sort order of Table / Chart with Slicer
    By thedesk in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-30-2021, 03:39 AM
  4. Slicer with month filter does not go in order
    By beastiaan in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 06-17-2021, 06:51 AM
  5. [SOLVED] Custom Sort Slicer By Calendar Order
    By brent_milne in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-02-2015, 09:07 AM
  6. How do I sort dates stored as 1-Jun-05 in order of day & month
    By stuckiniraq in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 10:05 AM
  7. How do I sort dates stored as 1-Jun-05 in order of day & month
    By stuckiniraq in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-06-2005, 03:05 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1