Home > Tableau, Tableau Basic > Tableau Display Measures in a Table

Tableau Display Measures in a Table

Displaying measures in a table in Tableau is something that should be straightforward but for some reason I always struggle with it hence I’m writing this blog post. In the Tableau screen at the bottom of the Dimensions section there’s a field called Measure Names and in the Measures section there’s a field called Measure Values. These are the 2 fields that make life easier when displaying data in a table.

Step 1 is to make sure the Marks value is set to Text so you can see the Text area. Drag the Measure Values pill into the Text area. This will then open a small section called Measure Values where it’s possible to drag, drop and re-order the pills that are displayed. Next step is to drag the Measure Names pill into the Columns section which gives a title to all of the measure values.

Now your table is built. You can also drag things into the Rows area if you want this table segmented – for example a time period to show the measure values over time.

To display dimensions in a table read my article about how to display multiple measures in a table.

  1. SF
    February 20th, 2013 at 16:48 | #1

    Thanks, this was a great help. I was getting ready to go to Excel to create my table until I found your article.

  2. Disha S
    August 5th, 2014 at 17:49 | #2

    How do you sort a table like this? I have built a similar table and would like to sort it by the “Number of Records”. When I right click the “Measure Names” in the column shelf and select sort, it only allows me to sort by the names and not the measure values.

    • awatson
      August 6th, 2014 at 18:44 | #3

      Great question. I assume if you want to sort the table you have a dimension on the Rows shelf? It’s this dimension that you want to sort, not the Measure Names, so right click the row dimension and select sort. If that doesn’t work another possibility would be to put the Number Of Records as a discrete dimension on the columns as the first column (i.e. to the left of Measure Names) and uncheck the ‘Show Header’ so it can’t be viewed. I don’t have Tableau with me to test either of these but one or both of these should work.

  3. Daniela
    April 7th, 2016 at 04:45 | #4

    Thanks! Always get stuck with this.

  1. May 28th, 2012 at 14:36 | #1
  2. December 18th, 2012 at 23:00 | #2