|Inclined to build a profession as Tableau Developer? Then here is the blog post on, explore Tableau Training|
Deleting a sheet removes it from the workbook You can delete the active sheet by right-clicking the worksheet or dashboard tab along the bottom of the workbook and selecting Delete Sheet. Worksheets used in a dashboard cannot be deleted, rather you can hide the worksheet.
How to Hide, Delete and Show WorkSheets in Tableau
Tableau is a leading business intelligence tool that helps business growth. It is easy to deploy, highly scalable and has an efficient framework performance. Here, we will explore how to hide, delete, and show worksheets in Tableau.
In Tableau, a workbook contains sheets. A workbook can have different types of sheets. It can be a worksheet, a dashboard, or a story.
Worksheet: It has a single view. The sidebar has shelves, cards, legends, and Data and Analytics panes.
Dashboard: It is a collection of views from multiple worksheets. The sidebar has the Dashboard and Layout panes.
Story: It has a sequence of worksheets or dashboards that work together to convey information. The sidebar has the Story and Layout panes.
Create new worksheets, dashboards, or stories
We can create many sheets in a workbook. There are many ways to create new sheets. To create a new worksheet, dashboard, or story:
The New Worksheet button.
To rename a new worksheet, dashboard, or story:
|Read these latest Tableau Interview Questions that help you grab high-paying jobs|
Hide and unhide all sheets in the dashboard
The steps to hide the entire dashboard or a story’s sheets are:
The steps to unhide the entire dashboard or a story’s sheets are:
The steps to hide an individual sheet are:
The steps to hide an unselected sheet are:
These steps will leave a blank space for the hidden sheets until a selection is made on the Map sheet.
The steps to unhide an individual sheet are:
Following are the steps to hide or unhide fields in the Data window.
To hide a field: Right-click the field and select Hide.
To change fields from hidden to visible: Select Show Hidden Fields on the data window menu.
To unhide a field: The hidden fields are greyed out in the data window. Select one or more hidden fields > Right-click > Select Unhide.
To hide all unused fields: Select Hide All Unused Fields on the Data window menu.
There are two options to go from a dashboard or story to a sheet:
1. On the dashboard, select the item that shows the hidden sheet. Click the drop-down arrow in the top left or right corner. Select Go to Sheet.
2. In the Sheets list, click the icon to the right of the sheet name.
The steps to go from a sheet to dashboards and stories are:
When you click a dashboard filter and all the sheets are greyed out, and you are unable to view further data, remove the highlight action to resolve the issue. To do this, follow these steps:
For in-depth knowledge of Tableau, click on below
You liked the article?
Like : 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.
Get stories of change makers and innovators from the startup ecosystem in your inbox