> ## Content Index
> Fetch the complete content index at: https://www.vizney.com/llms.txt
> Use this file to discover other available public pages before exploring further.

# Hiding Date Field Drill-Down in Tableau
- URL: https://www.vizney.com/hiding-date-field-drill-down-in-tableau/
- Published: 2025-06-15T12:55:32.000Z
- Updated: 2025-06-15T12:55:32.000Z
- Description: When a dashboard is built based on a specific date aggregation level, you can use Tableau’s custom date feature to prevent the drill-down button from appearing.
- Author: Yehwan Hwang
- Tags: Tips & Tricks

Tableau provides a default drill-down function for date fields, allowing users to easily change the level of date aggregation (e.g., year → quarter → month) and explore how metrics change over time.

💡

However, note that any custom formatting applied to the date axis will reset if the drill-down is expanded and then collapsed again.

If your dashboard is designed to compare metrics based on a fixed date level—such as year or month—this drill-down capability may confuse end users by allowing unintended changes in aggregation.

In such cases, Tableau’s [**Custom Date**](https://help.tableau.com/current/pro/desktop/en-us/dates%5Fcustom.htm?ref=vizney.com) feature can be used to disable the drill-down button entirely.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2025/06/Custom-Date-Menu.jpg)

By creating a custom date field with a selected aggregation level, you can display date fields without the drill-down arrow.

![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/2025/06/Custom-Date-Option.jpg)

During this process, remember that:

- **Date Parts** use the `DATEPART` function (discrete values like "January", "2024"),
- **Date Values** use the `DATETRUNC` function (continuous values like "2024-01-01").

For more details on the difference between these two options, please refer to our related post on date field aggregation in Tableau.

[Difference Between Top and Bottom Date Aggregation Options in TableauThis post explains the confusing aggregation options that often appear when working with date fields in Tableau.![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/icon/vizney_icon_b_1.0-18.png)VizneyYehwan Hwang![](https://storage.ghost.io/c/6a/50/6a50f03c-1922-4e90-bf18-c5abd0f819d4/content/images/thumbnail/Date-Field-Aggregation-Options_v2.jpg)](https://www.vizney.com/difference-between-top-and-bottom-date-aggregation-options-in-tableau/)