Highlight Tables in Tableau

In this article we will learn how to highlights the table in tableau worksheet to do further operations. 

Tableau – a brief note

Tableau could also be a really powerful data visualization tool which can be used by data analysts, scientists, statisticians, etc. to ascertain the data and acquire a transparent opinion supported the data analysis. Tableau is extremely famous because it can absorb data and produce the required data visualization output during a really short time.

Highlight Tables 

• The highlight table allows us to use conditional formatting to a view of a normal table.
• Tableau will automatically apply a color scheme in either endless or stepped array of colors from highest to lowest.
• It’s great for comparing a field’s values within a row or column.
• Use highlight tables to match categorical data using color.
• Highlight tables are often outstanding as they help users quickly spot the foremost interesting values during a table of numbers.
• In cases where multiple variables are displayed, Measure Values are often used to apply one color scheme to all or any of the values in a table.
• Unless the variables are very similar, highlighting multiple variables is typically not helpful and can mislead.

Dataset used in the given examples is Dataset.

Procedure

Steps to import the dataset :

1. Open Tableau tool and connect a dataset into it.
2. Drag and drop the one sheet of the connected dataset.
3. Click on sheet1 to open the tableau worksheet.
4. On clicking Sheet1 you will get whole dataset attributes on the left side and a worksheet for work.

To create a highlight table you have to form a table first by selecting the minimum two attributes( one in row and one in column) by drag and drop then select the chart option as highlight tables.

Example 1:

• Drag and drop the fields in columns and rows to create a table.
• Select the highlight tables from “show me” option.
• Apply marks by color for a better view.

Example 2:

• Drag and drop the fields in columns and rows to create a table.
• Select the highlight tables from “show me” option.
• Apply marks by color for a better view.
• Change the border color by selecting another color in “Border“ option.

Example 3:

• Drag and drop the fields in columns and rows to create a table.
• Select the highlight tables from “show me” option.
• Apply marks by color for a better view.
• Apply quick table calculation as “percentage” for analysis.