Disabling Drill Down of Date Fields

Published: 26 Sep 2013
Last Modified Date: 20 Dec 2019


How to disable drilling down on date fields.


  • Tableau Server
  • Tableau Desktop


The following instructions can be reviewed in the attached workbook.
  1. Select AnalysisCreate calculated field....
  2. In the Formula text box, type the formula similar to the one below, and then click OK.
    DATEPART('year', [<date-field>])
  3. Drag the calculated field into the view, replacing the original date field.

Additional Information

DATEPART returns the date as an integer. For months or days of the week, use DATENAME instead of DATEPART. For example:
DATENAME('month', [<date-field>])
DATENAME('weekday', [<date-field>])

To voice your support for the inclusion of this feature request in a future product release, add your vote to the following Community Idea: Ability to disable one-click drill-down.

Discuss this article... Feedback Forum
Did this article resolve the issue?