Select Page

Imagine adding a single chart in your report or dashboard that shows details and context all in one.

What if you could show all of the required information but make the most important details super clear.

…highlight tables are a great way to do that exact thing.

In this guide, you’ll learn how to create this chart type, plus some advanced options.

You can download the PDF version of this guide here.

Tableau Highlight Table Example

Get the bonus resources for this guide

Want to save some time or keep a copy of this guide for yourself?
Download the PDF version of this guide for free right now.

  • 7 Page PDF with screenshots for each step
  • Direct links for YouTube walk through and Tableau Workbook

Download Now

Examples of how you can use Tableau highlight tables

  • Comparing sales numbers for your teams or individual reps
  • Showing GPAs across grade levels or subject areas for students
  • Understanding changes in population sizes between towns or zip codes
  • Figuring out where you are spending your time at work or on home projects

Now – creating highlight tables in Tableau is actually incredibly easy. Just a few clicks, really.

But this guide goes much more in depth than just the basics.

I’ll show you the exact steps to recreate this exact Tableau dashboard.

View post on imgur.com

Quick links for each of the parts for this step by step Tableau highlight table tutorial.

  • Step 1: Connect to the data set
  • Step 2: Create the highlight table
  • Step 3: Create the top trend chart
  • Step 4: Create the right-hand side trend chart
  • Step 5: Create the final dashboard

By the way, these advanced highlight tables are sometimes called “marginal histogram charts” or even “heat maps”

Anyways, this guide will help you create a highlight table with multiple dimensions.

Step 1

Connect to the data set

Tableau Highlight Tables Data Connection Steps

Note: If you already have a dataset in Tableau, skip to step 2

  1. Open a new Tableau workbook
  2. In the Connect section, select “Web Data Connector”
  3. When prompted, enter the NYC Rat Sightings URL (http://tableau.data.world/?dataset_name=makeovermonday/2018w27-rat-sightings-in-new-york-city&query=SELECT%20*%0AFROM%20rat_sightings&queryType=SQL)
  4. Follow the prompts to finish up the connection

Step 2

Create the highlight table

Tableau Highlight Table Example Steps

  1. Drag Month(Created Date) to Columns section
  2. Drag Year(Created Date) to Rows section
  3. Create a Sightings field and set the value to [Number of Records]
  4. Drag Sightings to the Color section and also the Label section of the Marks card
  5. Rename the worksheet to Highlight Table and finish up formatting, text, colors, labels as needed

Note: if you want just a basic highlight table, you can stop after step 2

Step 3

Create the top trend chart

Tableau Highlight Table Monthly Trend Example

Time Saving Tip: Duplicate worksheets to keep field formatting and layout

  1. Duplicate the Highlight Table worksheet you just created
  2. Keep Month(Created Date) in the Columns section
  3. Remove Year(Created Date) from the Rows section
  4. Drag Sightings to the Rows section
  5. Drag Month(Created Date) to the Label section of the Marks card
  6. Rename the worksheet to Monthly Trend and finish up formatting, text, colors, labels as needed

Step 4

Create the right-hand side trend chart

Tableau Highlight Tables Yearly Trend Example

  1. Duplicate the Monthly Trend worksheet you just created
  2. Drag Sightings to the Columns section
  3. Drag Year(Created Date) to the Rows section
  4. Drag Year(Created Date) to the Label section of the Marks card
  5. Rename the worksheet to Yearly Trend and finish up formatting, text, colors, labels as needed

Step 5

Create the final dashboard

Tableau Highlight Table Dashboard Steps

  1. Create a new Tableau dashboard
  2. Drag each of the worksheets you’ve created to the dashboard canvas
  3. Make sure that the Highlight table container aligns with each of the trending bar charts
  4. Rename the dashboard to NYC Rat Sightings and finish up formatting, text, colors, labels as needed

Bonus Step

Tableau Dashboard Tips & Tricks

Tips on Tableau dashboard formatting

  • Focus on one design element at a time. For example, make sure that your colors are consistent for each worksheet.
  • Once you’ve got your colors all set, move to grid lines and borders.
  • Make sure that each of those is all set before moving on to labels, for example, for final formatting adjustment.
  • Adjust the padding for each worksheet container for proper spacing.
  • Remove any titles, legends, and other dashboard elements that aren’t needed

Final touches for your Tableau dashboard

  • Adjust chart and dashboard dimensions so that everything fits on one screen.
  • Add titles and subtitles so that it’s obvious what your dashboard is showing
  • Include filters and hover highlights to make your dashboard as useful as possible

Final dashboard – Link to Tableau Public

Tableau Highlight Table Dashboard Example

Tableau Highlight Tables Tutorial YouTube Walk through

Conclusion

In this step-by-step highlight table tutorial you learned

  1. Exactly how to create highlight tables using Tableau
  2. How to build more advanced highlight tables to make them even more powerful
  3. A few examples of how highlight tables can be used
  4. Everything needed to create an interactive Tableau dashboard that will impress your boss 🙂

Okay, now it’s your turn:

Take 20 minutes today and create a Tableau highlight table that you can share.

Shoot me a quick email (brian@newprediction.com) and I’ll share for you!

Get the bonus resources for this guide

Want to save some time or keep a copy of this guide for yourself?
Download the PDF version of this guide for free right now.

  • 7 Page PDF with screenshots for each step
  • Direct links for YouTube walk through and Tableau Workbook

Download Now

Tableau & Google Sheets Checklist

This one-page checklist PDF will help you learn how to upload your data into Google Sheets and build an awesome Tableau dashboard without wasting time.

You have Successfully Subscribed!

4 Things For Every Tableau Dashboard Creator

This free 4-page eBook PDF will walk you through the 4 most important steps for creating a Tableau dashboard

You have Successfully Subscribed!

Massive List of Tableau Tools

Tableau is even more powerful with these 20 tools you might not know about. The 2-page PDF includes a description and helpful links for each tool to get you started.

You have Successfully Subscribed!

Career Boosting Business Analytics Trends

Use this list as a road map to take you from boring data job to the GO-TO PERSON in your company that knows the answers to all the questions.

All set! Check your email :)

Massive List of Free Data Viz Books

Download the FULL listing of 10 free data visualization books covering dozens of topics across 100s of pages. All nice and neatly organized in an awesome Google Sheet for you to print or copy.

All set! Check your email :)

Tableau Dashboards: Beginner’s Guide (Free PDF)

Get the full 2-page PDF with the 5 steps outlined in this guide + 3 bonuses to help you along the way

BONUS #1: 5 Beginner mistakes to avoid

BONUS #2: Video walkthrough

BONUS #3: Links to the the Google Sheet and final Dashboard

All set! Check your email :)

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Massive List of Tableau Web Data Connectors(Free List)

Download the list of 21 different Web Data Connectors for Tableau in this Google Sheet (save a copy for yourself, too!) 

All set! Check your email :)

Slope Graph Examples PDF + Dashboard Walkthrough Video

This 4-page example PDF lists 10 examples of slope graphs curated from around the web with author links for each one. You'll also see the 16-minute walkthrough video where I create an interactive Tableau Dashboard from scratch. 

You have Successfully Subscribed!

Download the Tableau Tutorial PDF Checklist & Workbook

The step-by-step checklist for fixing busted charts with Tableau PLUS the full workbook with all of my formatting and calculations for free.

Tableau Tutorial Chart Redesign

You have Successfully Subscribed!

Download the TableauHighlight Tables PDF Guide

The step-by-step guide for creating Tableau highlight tables
(plus direct links to the YouTube video walkthrough and link to final Tableau workbook)

You have Successfully Subscribed!

How to Create 6 Different Tableau Bar Charts (Free Guide)

Get the step-by-step guide to create all 6 different types of Tableau Bar Charts (with copy-and-paste calculated fields included) for free.

 

All set! Check your email :)

Tableau Scatter Plots: The Complete Guide

Get the step-by-step checklist guide to create scatter plots with Tableau

 

All set! Check your email :)