4 of 4 people found this helpful
I've run into this problem myself. What I did to get around it was to not use Tableau's dates and create my own string field to output the values in the proper format for the parameter selection. Below is an example that would return properly formatted values for quarter, month and day. You can alter the formula to format the values to your specific needs. Let me know if you have any questions.
WHEN 'quarter' then DATENAME('year',[Order Date])+'-Q'+DATENAME('quarter',[Order Date])
WHEN 'month' then DATENAME('year',[Order Date])+'-'+STR(DATEPART('month',[Order Date]))+'-01'
WHEN 'day' then STR(DATEPART('month',[Order Date]))+'-'+DATENAME('day',[Order Date])+'-'+DATENAME('year',[Order Date])
****, u rock! Thank you for this suggestion.
I'm having similar issue, can you please share your worksheet?
I get an error while opening this workbook
Tableau Desktop version may be an issue.
Workbook build version is 10.3 or please share the screen shot of the error message.
It worked Fine !!
Thanks for sharing
Hi there Ivan :-) I am using your method, but I have noticed that the displayed dates are comparative rather than sequential. Would it be possible for you to modify the formula so that the displayed date is in sequence? e.g. January, February, March, April, etc.
Thank you again for your hard work.