Showing Header for Text Table with Single Measure in Tableau
I had a question from one of my students tonight about how to show the header for text table with a single measure. It’s not super straightforward to do this in Tableau. You can’t simply to go the measure pill and show the header (because it doesn’t have it).
Let’s recreate the default Tableau behavior first, using Superstore Sales.
1. Double click on a dimension, for example, Product Category
2. Double click on a measure, for example, Sales
What you will get is something like this:
A quick Google search lands me to the ideas forum from Tableau: http://community.tableau.com/ideas/1891 . This page contains several threads of ideas on how to accomplish this task.
To summarize, here are a couple options to show the header.
Option 1 – Measure Names and Measure Values
Credit to Tracy Fitzgerald for this solution
1.Use Measure Names in your Columns, and filter by only the single measure.
2.Instead of having the measure – SUM(Sales) – in the Text Marks Card, use Measure Values.
Option 2 – Dummy Calculated Field
Credit to Jonathan Drummey (Tableau Zen Master) for this solution
1.Create a calculated field that will contain the header you want to display
2.Use the dummy calculated field in your Columns shelf
3.Hide the field label for the column