Tableau Dimensions and Measures

Every field in your Data Pane belongs to one of two categories: Dimensions or Measures. This is the most fundamental concept in Tableau. Getting this right determines whether your charts make sense.

The Simple Explanation

Dimensions are categories — they describe what something is. Measures are numbers — they describe how much of something exists.

Grocery Store Analogy

Grocery Receipt
-----------------------
Item      | Qty | Price
-----------------------
Apples    |  4  | $2.00
Bananas   |  6  | $1.50
Milk      |  2  | $3.00

Dimensions = Item name (Apple, Banana, Milk)
             — These are categories/labels

Measures   = Qty and Price
             — These are numbers you can add, average, or compare

Dimensions in Tableau

Dimensions appear in the top half of the Data Pane in blue. They contain qualitative values — names, categories, dates, and IDs. Tableau uses Dimensions to slice and group data. When you drag a Dimension to the Rows or Columns shelf, Tableau creates one section per unique value in that field.

Examples of Dimensions

  • Product Category (Furniture, Technology, Office Supplies)
  • Customer Name
  • Region (East, West, South, Central)
  • Order Date
  • Country or City

Measures in Tableau

Measures appear in the bottom half of the Data Pane in green. They contain quantitative values — numbers you calculate. When you drag a Measure to the view, Tableau automatically aggregates it (adds it up, averages it, etc.). The default aggregation is SUM.

Examples of Measures

  • Sales
  • Profit
  • Quantity
  • Discount
  • Shipping Cost

How They Work Together

Think of Dimensions as the X-axis labels and Measures as the bar heights. You always use at least one Dimension and one Measure to build a meaningful chart.

Diagram: Dimension + Measure = Chart

Drag "Region" (Dimension) to Columns
Drag "Sales" (Measure) to Rows

Result:
Sales ($)
  ^
  |  [=====]          [===========]     [========]      [=======]
  |  Central             East             South           West
  +-------------------------------------------------------------> Region

Discrete vs Continuous

Both Dimensions and Measures can appear in two modes: Discrete or Continuous. This changes how Tableau draws axes and headers.

Discrete fields create separate buckets. Each value gets its own header or section. Discrete fields appear in blue on the shelves.

Continuous fields create a flowing axis with no gaps. The axis runs from minimum to maximum. Continuous fields appear in green on the shelves.

Visual Difference

Discrete Date (Dimension — Blue):
  2021 | 2022 | 2023 | 2024
  Each year gets a separate column header

Continuous Date (Measure — Green):
  |---2021---2022---2023---2024---|
  A single flowing timeline axis

Practical Rule

Use Discrete for category labels (product names, regions). Use Continuous for time axes and number ranges (date trends, profit scales).

Right-Click to Switch

You can switch any field between Discrete and Continuous. Right-click a field on a shelf and select "Convert to Continuous" or "Convert to Discrete." Tableau updates the chart immediately. This works on both Dimensions and Measures.

Geographic Dimensions

Fields like Country, State, and City carry a small globe icon. Tableau recognizes these as geographic Dimensions. When you drag them to the view, Tableau can automatically build a map instead of a bar chart. Geographic fields work as both Dimensions and map location markers.

Measure Names and Measure Values

At the very bottom of your Data Pane, you see two special fields: Measure Names and Measure Values. These are generated automatically by Tableau.

Measure Names — a Dimension that holds the names of all your Measures as text values.

Measure Values — a Measure that holds the actual numbers for all your Measures in one combined field.

Together they let you compare multiple measures side by side on a single axis, which is useful for building combination charts.

Summary

Dimensions describe categories (blue, qualitative). Measures describe numbers (green, quantitative). Every chart needs at least one of each. Discrete fields create separate buckets; Continuous fields create a flowing axis. Tableau lets you switch between modes with a right-click at any time.

Leave a Comment

Your email address will not be published. Required fields are marked *