• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to sort month in slicer

Wilco()

Member
I have slicer with months. And it sorts it by alphabet (apr, aug) instead of month (jan, feb, mar).

Is there a function/option in marval to have it select the 'natural' sorting for dates (month)?
 
Good day Wilco()

Not sure how you have your pivot set up but if you look at the upload you will see then in the order of the data....but what do you mean by "marval"
 

Attachments

I am mixing things up, where I said Marval I meant Excel.

I found that it has to do with my locale settings. When I enter the month names in Dutch I can sort them (using the sort more options). o_O
In the excel sheet you have uploaded it is still ordered using the english languages. :confused:

Still do not know how to overcome in my excel sheet. How can I circumvent this?
 
Last edited:
Back
Top