Last Modified Date: 26 Aug 2019
Environment
Tableau DesktopAnswer
CLICK TO EXPAND STEPS
Option 1
The attached workbook (see upper right hand corner of this web page) uses the example data set Superstore to demonstrate the following directions.
Use the Exclude All Value option of the Filter action to collapse target sheets under their titles, hiding all data.
Step 1 - Build the views
Use the Exclude All Value option of the Filter action to collapse target sheets under their titles, hiding all data.
Step 1 - Build the views
- Drag [Region] to the Rows shelf and another instance of [Region] on Color.
- Create a new sheet, and drag [Sales] to the Columns shelf.
- Drag [Segment] to the Rows shelf.
- Create a new Dashboard and drag the newly created sheets to it.
- Navigate to Dashboard > Actions…
- In the Actions dialog, click Add Action > Filter…
- In the Edit Filter Action dialog, do the following:
- For Source Sheets, check only Sheet 1.
- For Run Action on, choose Select.
- For Target Sheets, check only Sheet 2.
- For Clearing the selection will: select the option "Exclude Value"
- Click OK to close all dialogs.
CLICK TO EXPAND STEPS
Option 2
The field [Segment] will never be equal to "", which is the value of [Blank]. Therefore, whenever this Filter Action is run, all of the values in "Sheet 2" will be filtered out, and "Sheet 2" will disappear.
Step 1 - Build the views
Step 1 - Build the views
- Drag [Region] to the Rows shelf and another instance of [Region] on Color.
- Select Analysis > Create Calculated Field
- Name the calculated field "Blank", enter the following formula and click OK:
""
- Drag [Blank] to Detail.
- Create a new sheet, and drag [Sales] to the Columns shelf.
- Drag [Segment] to the Rows shelf.
- Create a new Dashboard and drag the newly created sheets to it.
- Navigate to Dashboard > Actions…
- In the Actions dialog, click Add Action > Filter…
- In the Edit Filter Action dialog, do the following:
- For Source Sheets, check only Sheet 1.
- For Run Action on, choose Select.
- For Target Sheets, check only Sheet 2.
- For Target Filters, select the Selected Fields radio button.
- Click Add Filter…
- In the Add Filter dialog, do the following:
- For the First Field dropdown, select Blank.
- For the Second Field dropdown, select Segment.
-
Click OK three times to close all dialogs.
Additional Information
To view the above steps in action, see the video below.Note: the video has no sound.
Discuss this article... Feedback Forum
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials