Data dell'ultima modifica: 30 Mar 2023
Ambiente
- Tableau Desktop
Soluzione
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".
Causa
This feature is not built in Tableau Desktop yet.Ulteriori informazioni
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.Grazie per aver inviato il tuo feedback sull'efficacia dell'articolo.
Apri nuovo caso
Continua la ricerca
Knowledge base
Community
Guida
Formazione e tutorial