KNOWLEDGE BASE

Filtering Only Relevant Values Returns Unexpected Results in Dashboard


Published: 28 Feb 2014
Last Modified Date: 29 Aug 2016

Issue

When adding a sheet to a dashboard, where the sheet uses a filter configured with the Only Relevant Values option, the filter might continue to display values that have been removed from the view.

Environment

Tableau Desktop

Resolution

  1. Go to the sheet where the context filter is located.
  2. Right-click on context filter and select Apply To Worksheets > All Using This Data Source.

Cause

Filters are associated with a single sheet, and compute the relevant values based on the context of that sheet. When filters are created in a dashboard, it can be confusing which filter belongs to which sheet. Applying the context filter to all sheets removes any confusion.
Did this article resolve the issue?