Dimensions vs Measures in Tableau, With Examples
Updated · By Robert Breen
The problem
Marcus, a sales manager, drags "Store ID" onto a chart and gets one bar that says 4,812,330. He expected one bar per store. Nothing is broken; Tableau added up the store numbers because it treated them as a measure.
What you’ll be able to do
You will be able to look at any table and say which columns are dimensions and which are measures, predict what a chart will show before you build it, and fix the "one giant number" problem in seconds.
The rule of thumb
A dimension answers "by what?" (by region, by month, by product). A measure answers "how much?" (how much revenue, how many orders). Put a dimension on a chart and you get one mark per value. Put a measure on it and Tableau summarizes it with an aggregation, usually SUM.
A worked example
| Order date | Region | Store ID | Product | Units | Revenue |
|---|---|---|---|---|---|
| 2026-09-01 | East | 1021 | Desk lamp | 3 | $135 |
| 2026-09-01 | West | 2040 | Monitor arm | 1 | $89 |
| 2026-09-02 | East | 1021 | Monitor arm | 2 | $178 |
| 2026-09-02 | West | 2055 | Desk lamp | 4 | $180 |
Dimensions: Order date, Region, Store ID, Product. Measures: Units, Revenue. Revenue by region from these four rows: East = $135 + $178 = $313, West = $89 + $180 = $269.
Store ID looks like a number, but adding store IDs together means nothing. That is exactly Marcus’s problem: Tableau guessed "number, so measure". The fix is to tell Tableau it is a dimension (in the Data pane, right-click the field and choose Convert to Dimension), and the chart splits into one bar per store.
Blue and green, discrete and continuous
In Tableau, fields show as blue or green pills. Blue means discrete: separate values, which make headers or separate bars. Green means continuous: a range, which makes an axis. Most dimensions are blue and most measures are green, but dates can be either: a blue month gives 12 separate columns, and a green month gives a timeline.
If a chart looks wrong, check the pill color before anything else. Most beginner surprises are a field that is discrete when you wanted continuous, or the other way round.
Three mistakes that give wrong totals
Adding up IDs, ZIP codes or years. Convert them to dimensions.
Averaging an average. If each row already holds a store’s average order value, SUM gives nonsense and AVG gives an unweighted average. Bring in the raw totals (revenue and order count) and divide them in a calculated field.
Counting rows when rows are not orders. If each row is an order line, three lines on one order count as three orders. Use COUNTD (count distinct) on Order ID.
Check your understanding
A column holds ZIP codes. Is it a dimension or a measure?
Show the answer
Dimension. You group by ZIP code; you never add ZIP codes up. Tableau may guess "measure" because they are numbers, so convert it.
From the example table, what is total Units for the Desk lamp?
Show the answer
7. 3 (East, Sept 1) + 4 (West, Sept 2) = 7.
A green date pill on Columns gives you…
Show the answer
A continuous timeline axis. Green means continuous, which draws an axis. Blue (discrete) would give separate headers.
Sources
Checked against these official help pages on . Menus change, so if a button has moved, the help page has the current wording.
- Dimensions and Measures, Blue and Green
- Convert a Measure to a Dimension
- Convert Fields Between Discrete and Continuous
Terms in this lesson
Questions this lesson answers
- Should I learn Tableau or Power BI first?: Learn the BI tool your employer, or the one you want, uses. If none, Tableau on a Mac or Power BI on Windows. The core ideas transfer…
- What does a BI analyst do?: A BI analyst turns business questions into trusted numbers and dashboards. What the job involves day to day, the skills it needs and how…