Last Modified Date: 13 May 2020
- Tableau Desktop
- Tableau Server
- Filtered data
ResolutionThe following workaround is demonstrated in the attached workbook.
Option 1Set the original worksheet to floating and place a floating text or image object behind the original worksheet. When the original worksheet is filtered to no data, then the floating object will show.
Note: A field must be in the view in addition to having a field on Text. In the attached sample workbook, the field "Blank" is used.
Option 2Create a dummy worksheet that has the expected text or numeric value that has the opposite filter settings as the original worksheet. Place both worksheets in a layout container on the dashboard. When either worksheet is filtered to no data, then that worksheet will collapse.
Option 3Add a row to the data source for every unique combination of filter values. These rows can be entirely blank except for the fields used as filters. Then create a calculation that replaces NULL data with the desired value.
To voice your support for the inclusion of this enhancement in a future product release, add your vote to the following Community Idea: Replace Blank Dashboard Charts With a Text Field
Discuss this article...
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Training and Tutorials