How To Hide The Rows For A Date Dimension On Pages Shelf

Published: 13 Sep 2020
Last Modified Date: 08 Jul 2022


How to hide the rows for a date dimension on Pages shelf.
Example: Hide all the months except the ones already navigated i.e hide ALL except the first two dates in the below picture
User-added image


  • Tableau Desktop


1. Create a date parameter with dates from the Data source
User-added image
2. On the dashboard, Create a change parameter action 
User-added image
3. Create a calculated field like below:

[Date] <= [Date param]

4. Drag to Filter Shelf on the Table sheet and select True

Now when you hover over the state, the date values are passed to parameter and the table adds up only those value less than or equal to the the date value on Page

User-added image


Additional Information

Please check the video for demonstration of steps in action
Did this article resolve the issue?