3 Replies Latest reply on Nov 8, 2013 9:31 PM by Ramon Martinez

    Year - Month Slider

    William Andrus


      I tried two techniques for creating a Year - Month Slider.

       

      1) Right-click date field. Select "Create Custom Date...". Select "Month / Year" Date Part. Then used that as my filter.

      2) Converted date to integer on SQL-Server and then in Tableau right-click field. Select "Default Properties". Select "Number Format". Then custom format to "YYYY-MMM".

       

      Both techniques work perfectly within Tableau Desktop, but once uploaded the formatting disappears in the web browser. Technique 1 changes it back to an integer, giving possible date values for year / month like: 201315. Technique 2 loses format back to the date integer values like: 41471

       

      Is there a year / month technique that works on the web?