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.
