KNOWLEDGE BASE

Quick Filters Display "No items" When Using a Sheet Selector Parameter On a Dashboard


Published: 26 Jul 2014
Last Modified Date: 13 May 2016

Issue

When using a filter configured to show Only relevant values in a dashboard, the sheet selector might display "No Items".

Environment

Tableau Desktop

Resolution

Option 1

Change the filter to use All values from database. For more information, see General Quick Filter Options.

Option 2

Add the affected filter, and any filter used to determine the relevant values, to the context: 

  • Right-click on the affected filter.
  • Select Add to Context.
  • Navigate to the dashboard. 
  • Edit the relevant filters by using either All values in database or All values in context.

Cause

Context filters are evaluated before regular filters and therefore only the filters in context will be used to set the relevant values for the quick filter in question. For more information, see Context Filters.

All filters on the Filters shelf are used to determine relevant values. When using a parameter to switch worksheets on a dashboard, there is a filter that filters out all data on any unselected worksheet. If the worksheet that hosts the quick filter is not selected, no value will be showed because all values have been filtered out.
Did this article resolve the issue?