KNOWLEDGE BASE

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


Published: 13 Sep 2020
Last Modified Date: 14 Sep 2020

Question

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

Environment

  • Tableau Desktop

Answer

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?