22 Nov Hiding Text in Tableau Worksheets
Just like Microsoft Excel, Tableau uses a workbook and sheet file structure. A workbook contains sheets. A Tableau worksheet has a single view with shelves, legends, cards, and the Data and Analytics panes in its sidebar. A sheet can be a worksheet, a story, or a dashboard. While working with worksheets in Tableau, you might want to hide some text. In this article, I will walk you through the steps in hiding text in Tableau worksheets.
Click on the sales in the text marks card and click the formatting option in the dialogue box that pops out.
Click on the Default option and navigate to the font dropdown. Change the font to white/ desired color to hide text details.
Navigate to the Grand Total Option and click the font dropdown to change the Grand Total to its desired color.
Before
After
For Heatmap Visualization
From the Visualization below
Convert the Mark type from Automatic to Square
Increase the Bar Size to the highest
Add Sales to both color and details card
Remove the sales from the text card
Create a calculated Field called Grand Total
Drag the calculated field to the column shelf and convert the field to discrete
This is the result below
Create an Adhoc Calculated with ““to create a divider.
Drag this to both row and column shelf
Then hide the header to structure the view properly
Format the row and column divider
Change the color of the row and column dividers
The final Result without the text in the heatmap
And that’s how to hide text in Tableau worksheet. If you found this post helpful, feel free to share it with your friends.
No Comments