Last Modified Date: 07 Aug 2020
- Tableau Desktop
- Tableau Server
ResolutionTo resolve this issue, use one of the following workarounds:
Option 1:Use a relative date filter. For more information, see Quick Start: Relative Dates in Tableau Help.
Option 2:Include dummy values in the data set for future dates or the expected largest/smallest measure value.
When dummy values are included in the data, the Range of dates or Range of values filter will show those values, even if they don't have any additional data associated with them. Then, as the data is added for those values, the filter will automatically pick up the data for those values.
Option 3:Use Non-null values in the filter. When this special value is selected, then the range of dates or range of values filtered will bring in new dates or values when the underlying data is updated
- Right-click the filter on the Filters shelf and select Edit Filter…
- In the Filter dialog, click the Special tab
- For Special, select Non-null dates and click OK
- Open the filter options from filter in the view (click drop down)
- Select 'Only Relevant Values'
- Reopen options and select Customize > Show Null Controls
- Select 'Non-Null Values Only' from new option on filter
CauseThe Range of dates or Range of values filter is designed to leave the values at the last selected value when the workbook is reopened regardless of changes in the underlying data.
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials