Last Modified Date: 30 Mar 2023
Environment
- Tableau Desktop
Resolution
As a possible workaround, create separate sheets to display only the data you want to freeze and the other data, and place them on a dashboard:1. Connect to Sample - Superstore.
2. Change the name of sheet to "Freeze" from "Sheet 1".
3. Drag [Category] to Columns.
4. Drag [City] to Rows.
5. Drag [Sales] to Text.
6. Drag [City] to Filter Pane > Push 'None' > Check "Akron"
//Assume this time that we want to freeze Akron's data.
7.Duplicate sheet "Freeze" and rename it to "Non-Freeze".
8. Right click on "City" in the Filter Pane > Edit Filter > check "Exclude" > OK
9. Right click on "Category" in the Rows > Show Header
10. Right-click on the "City" column of the Crosstab > "Hide Field Labels for Rows"
11. Toolbar > Format > Shading > Set Band Size of Row Banding to the leftmost.
12. Create a new Dashboard.
13. Set the Object to Floating > Drag the sheet "Freeze" to the dashboard.
14. Set the Object to Floating > Drag the sheet "Non-Freeze" under the "Freeze".
15. Set the title of the sheet "Non-Freeze" to be hidden.
16. Adjust the position of the sheet "Non-Freeze" to match the position of the "Freeze".
17. Adjust column widths of sheet "Freeze" to match the width of "Non-Freeze".
Cause
This feature is not built in Tableau Desktop yet.Additional Information
To voice your support for the inclusion of this enhancement in a future product release, add your vote to Adding a freeze row, pane, or column functionality.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
Trending Articles
Results 1-3 of 50