How to the sort vales in my Filter panel

[Verticurlqlik]

Hi There

How to the sort vales in my Filter panel as shown in the screenshot. I've a pivot table in my dashboard with region and month filter's, but in month it is not in order. Please help on this.

Thanks

Nandhakumar

[Arthur_Fong · Accepted solution]

Try formatting your date to date format. Currently the date is in text format:

date#([Date Field],'MMM-YYYY') as Date

[Verticurlqlik]

Hi JK

Thanks for your reply

Will it impact in filter value listing also?

Thanks

Nandhakumar

[Arthur_Fong]

Where did you apply filter in? Script or Set analysis?

[Verticurlqlik]

Hi JK

Actually i have a pivot table and a field called Month, there i'm using month filed in as filter option. So, not having any script or set analysis here.

Thanks

Nandhakumar

[Arthur_Fong]

Can you try formatting your date column first?

Possibly your date column is set as text and it couldn't reflect the correct sort order for date.

[Verticurlqlik]

Sure JK

will fix in data and check again as guided. Thanks again

[wayne-a]

Also be sure to check the sorting section on the pivot table properties and be sure that the settings are correct for your date field.  Here is an example of one.