KNOWLEDGE BASE

Filter with "Only relevant data" or "All values in context" Shows Unexpected Results in 2022.2


Published: 09 Aug 2022
Last Modified Date: 11 Aug 2022

Issue

Filter with "Only relevant data" or "All values in context" shows unexpected data in Tableau Cloud and Tableau Desktop starting with version 2022.2.

This issue only occurs when there is a related Dimension filter that excludes NULL data.

 

Environment

  • Tableau Cloud
  • Tableau Desktop 2022.2 

Resolution

Option 1:

Use a data source filter to exclude the NULL data.

Option 2:

Filter the NULL data using a calculation field with the ISNULL() function.

Cause

This behavior is related to a Known Issue with ID 1440525, that is currently under investigation.
Did this article resolve the issue?