How to display Decending or Ascending order value in Quick Filter? Just say I have Date quick filter and default sorting order is ascending.
01/31/2011
02/28/2011
03/30/2011
Now I want these values in DESC sorting order in Quick filter.
03/30/2011
02/28/2011
01/31/2011
how to do this?
I had the similar problem and I am using Tableau 9 desktop. This is how i achieved descending order for my date field quick filter. Right click on the date field and transform the field to a new custom date field and then set the default sort property to descending. Now include this new field as a quick filter (this new field is essentially the same field)
Please check my attached screenshots.
I am transforming my "WeekEnding" date field to a custom date field, which is called WeekEnding (Month / Day / Year) then set the default sort property of WeekEnding (Month / Day / Year) to Descending. (Right click on the field --> Default properties --> Sort --> Descending)
Included WeekEnding (Month / Day / Year) as quick filter, renamed the title of the quick filter to "Week Ending"