Tableau Hack: Remove Unwanted Highlighting

by Cecily Santiago

In Tableau, marks get highlighted when you click them, causing all other marks to fade into the background.

A bar chart with nothing highlighted
The same bar chart with one bar highlighted

This can be slightly annoying for someone like me who compulsively clicks their mouse, or cause issues with the ability to read the rest of a chart when clicking a mark to activate a parameter or set action. Here's how to use a calculated field and a highlight action to turn off this highlighting feature.

  1. Create a dummy field.
    1. Click the down arrow in the data pane and select "Create Calculated Field." I'll call mine "Dummy," but you can call it anything you want.
    2. Fill it with any string you want.
  1. Drag your dummy field onto "Detail" on the marks card. This gives us access to the field within our worksheet.
  1. Create a highlight action for this sheet.
    1. Go to the "Worksheet" menu in the menu bar
    2. Select "Actions..."
    3. Choose "This sheet."
    4. Click "Add Action" and select "Highlight"
  1. Format the highlight action and click OK
    1. Give it whatever name will help you identify it later
    2. Set the source and target sheets to the sheet you're working on
    3. Choose "Run action on: Select"
    4. Set "Target Highlighting" to "Selected Fields" and then select only your dummy variable.

Now, when you select a mark, the other marks should stay bright as well!

The same bar chart with the same bar selected--but no longer highlighted!

Essentially, we haven't turned off highlighting. Rather, we've told Tableau to highlight all the marks by telling it to highlight anything with the same value in our dummy field as the selected mark, and they all have the same value in that field. However, highlighting everything has the same effect as highlighting nothing.