KNOWLEDGE BASE

Sheet Selector Not Behaving As Expected


Published: 24 Mar 2015
Last Modified Date: 27 Nov 2017

Issue

When trying to create a sheet selector, sheets do not switch as expected.

Environment

Tableau Desktop

Resolution

Try one of the following:
  • Ensure that all sheets meant to be switched out are in the same layout container.
  • Ensure that all sheets meant to be switched out are tiled rather than floating.
  • Create a dummy dimension set to a value of 1, drag it on to Rows and/or Columns, and deselect Show Header.
  • 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: 
  • Worksheets are not in the same layout container.
  • 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. 
  • 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).
  • 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?