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.