Building a table of multiple measures in Tableau is straightforward. You can build the table using only two pills.
Use the dimension Measure Names and the measure Measure Values.
This also works to compare multiple measures side by side in a Tableau bar chart. Building the multiple measures bar chart is covered towards the end of this article.
Build a table in Tableau using Measure Names and Measure Values
Follow these steps to build a simple Tableau table:
Step 1: Put the Measure Names pill on Columns.
Step 2: Notice the Mark Type default to Text. If this doesn’t happen by default then set the Mark type to Text.
Step 3: Add Measure Values. Either drop it on the ABC column, double click the field within the list of Measures, or drop it on the Text shelf. All will have the same outcome.
Step 4: Put Measure Names to the Filter shelf and choose the measures to display. Either ctrl-click-drag from Columns or drag from the Dimensions list. It’s possible to use Measure Names as a user filter.
Step 5: (optional) Reorder the measures by rearranging the Measure Values section. It’s also possible to filter using this section – simply drag the unwanted pills out of the Measure Values box.
Build a Heatmap in Tableau
This technique also works to build a heatmap across multiple measures.
To build the heatmap add a dimension to rows. This isn’t essential but makes it look better for this demo.
Change the mark type to Square, then also add Measure Values to the Colour shelf. Measure Values will be both on the Colour and Label.
This is also the simplest way to do conditional formatting in Tableau.
In addition, using Measure Names / Measure values is one way to get around the 16 column limit Tableau imposes on tables.
Perhaps your requirements are more sophisticated than is possible using the simple Measure Names / Measures Values. It’s also possible to build tables using the placeholder technique, which gives more flexibility.
Build a bar chart using multiple measures
Measure Names and Measure Values is used to build a bar chart with multiple measures. Very useful if to compare measures side by side in a bar chart.
To build this is very similar to the above. Instead, the Measure Values is on Rows and the Mark Type a bar. This enables multiple measures to be compared side by side in the same bar chart.