How to add Transparent Worksheets to your dashboards in Tableau – Skill Pill Video

Transparent Worksheets in Tableau Software btProvider

Are you ready for a new great visualization in Tableau Software? Today we will focus on a different feature in Tableau. Precisely, we will discuss a new way to improve the visual impact of our analyzes. In today’s post we will see how we can add transparent worksheets in Tableau and how it can create a more pleasant visual experience for the end user. Although most of the time our posts have the role of educating the public with new methods of using Tableau products for data analysis, we thought it would be time to discover some features with more visual potential.

Transparent worksheets in Tableau can be applied to worksheets in dashboards. The most important thing to remember is that these transparent worksheets allow users to add different layers, one on top of the other, such as: graphics over a certain image, graphics over a map or graphics over graphics. Basically, this feature offers more freedom to users in terms of designing graphs or analyzes with a higher impact.

How to add Transparent Worksheets in Tableau

Even though it is an impactful feature, Tableau users rarely use it. However, we would like to present some of the advantages of using these transparent worksheets because they are an excellent way to add context to our analysis. First, a transparent worksheet allows us to add several layers on top of each other, without loading the final visualization and without confusing the end user. Secondly, transparent worksheets in Tableau are also a great way to make a comparison in a dashboard, between two or more graphs.

Last but not least, transparent worksheets allow user to add a background image that provides more context to the final view and that better conveys the information in the analysis. The background images added behind them can be images specific to the data, company-specific logos or banners, maps and much more. The background images added behind the transparent worksheets do not influence the analysis and interactivity of the final view. Users still can highlight or select content, depending on their needs.

In the video below you will see how you can add transparent worksheets to Tableau and what are the steps you need to go through.

Step 1: Connect to data

→ In Tableau Desktop, connect to to Tableau: Sample-Superstore.

Step 2: Create the visualization

→ Create a sheet: ‘Map

→ Double-click on County

→ From Marks, select Map

→ Drag ‘Internet Usage’ on Colorsand select AVG

→ Create a sheet: ‘Evolution

→ Drag Year on Columns

→ Drag County on Columns

→ Drag ‘Internet Usage’ on Rows

→ Filter NULL values

→ In Dashboard, bring a Container(Vertical) and insert the two sheets

→ Select Format > Shading > Worksheet > None, for the two sheets

→ For Map sheet, select Map Layers and select only Coastline

→ From Objects, drag Image, while you hold Shift to be Floating

→ From Layout, select Remove From Dashboard for Tiled

→ The image must be under Vertical Container

By Eduard Arhire

Download Tableau Software