KNOWLEDGE BASE

Sheet Selector Not Behaving As Expected


Published: 24 Mar 2015
Last Modified Date: 17 Apr 2017

Issue

When trying to create a Sheet Selector, the desired effect of toggling sheets does not work as expected.

Environment

Tableau Desktop

Resolution

Try one of the following workarounds:
  1. Create a dummy dimension set to a value of 1, drag it on to Rows and/or Columns, and deselect Show Header
  2. When assembling the dashboard, use the Fit Selector to size each pane as desired, rather than adjusting them manually via drag and drop

Cause

The issue might be caused by one or more of the following root causes: 
  1. The view may have been constructed in such a way that empty column and/or row headers persist when one or both views are nulled out. 
  2. If there are no dimensions in columns or rows, filtered views still retain their 'blank' space. If there are dimensions, the filtered view will be completely filtered (gray background).
  3. At some point when the dashboard was being assembled, worksheet panes were manually resized, preventing the "switching" effect from properly occurring.
Did this article resolve the issue?