KNOWLEDGE BASE

View is Blank When Filtering to Only One Value in Calculated Filter that Uses Parameter


Published: 24 Jul 2019
Last Modified Date: 20 Sep 2019

Issue

When filtering to one dimension member of a calculated field that swaps between an imported string field and a calculated field that returns a string literal, saving, closing, and reopening the workbook, then filtering to that one dimension member will show a blank view.

Environment

Tableau Desktop

Resolution

Option 1

Upgrade to Tableau Desktop 2019.3 or a newer version. See Tableau Desktop Downloads and Release Notes for downloads of current and previous versions of Tableau Desktop.  For more information on current releases, see Upgrade Tableau Desktop and Desktop Upgrade.

Option 2

As a workaround, copy the formula of the nested calculation that returns a string literal and paste that into the calculation being used as a filter.

Cause

This is a known issue ( IDs: 940685 and 956906) that has been fixed in Tableau Desktop 2019.3.
Did this article resolve the issue?