Get Ready For Your Tableau Certification
  • Bernard

Tableau charts: Highlight tables

Updated: 2 days ago


Definition

Highlight tables are used to compare categorical data using color. Just like the name suggests, highlight tables adds color highlights for users to read the table more intuitively and effectively.

A good example of a highlight table is in this dashboard on (Visitors to Kenya between 1991-2014)

Step by step on how to create a highlight table in Tableau.

In this post you're going to learn how to create a highlight table to explore how Profit varies across product Sub-Category's for different Regions.

  • Connect to Superstores data sets pre-loaded in Tableau app.

  • Drag dimension field Sub-category to the Rows shelf.

  • Drag dimension field Region to the Columns shelf.

  • Drag measure field Profit to the Label tab under Marks cards.

See the resulting Table.

Next, select 'Highlight tables' under the Show Me tab.

Executing above we have.

Adding some formatting and color adjustments we have.

From the above table, users can spot at a glance the Regions and Sub-category's recorded profit or loss. For instance, the most profitable Sub-category, copiers in the West Region can be spotted without strain. While the most Unprofitable Sub-category, Tables in East Region can be spotted too.

More statistics like grand totals can also be added by going to Analysis menu >>Totals >> Show Row Grand Totals or Show Column Grand Totals.

Useful: Learn how to use separate legends in your view (legends per measure)

I hope this article was helpful to you. To receive more of the Tableau tips, kindly join our mailing list by subscribing below.

Thanks for reading.

#charts

1.png
2.png