What is the Difference Between Discrete and Continuous in Tableau?
One of the first things you notice in Tableau is that some fields you drag onto your worksheet turn into blue "pills," while others turn green. This isn't just a design choice, it’s Tableau’s way of showing you the fundamental difference between discrete and continuous data. Understanding this distinction is one of the most important concepts for mastering Tableau and building effective visualizations.
This tutorial will break down exactly what discrete and continuous data are, how to use them, and why the blue and green pills behave differently. We'll cover everything from how they create axes versus labels to how they change the way your filters work.
What Are Those Blue and Green Pills, Anyway?
Think of the colors blue and green as a quick visual guide to how Tableau is treating your data. In the simplest terms:
- Blue Pills are Discrete: They represent individual, separate categories. Think of them as individual buckets or labels.
- Green Pills are Continuous: They represent an unbroken range of numerical values. Think of them as a measuring tape where values can fall anywhere along the line.
Whenever you drag a field from the Data pane onto a shelf (like Rows or Columns), Tableau automatically classifies it as either discrete or continuous and colors it accordingly. This classification dictates how the visualization is built. Let's look at each one more closely.
Understanding Discrete Fields (The Blue Pills)
Blue pills are for data points that are finite and have distinct, separate values. When you use a blue pill in a view, you are sorting and organizing your data into categories.
What Makes Data Discrete?
Data is discrete if its values are individual and can be counted. You can't have half of a category. These values don't have a natural middle ground between them.
- Examples of Discrete Data: Customer Names, Product Categories ('Furniture', 'Office Supplies', 'Technology'), Geographic Regions ('East', 'West', 'Central'), or Order IDs.
In all these cases, each value is a unique label. There is no mathematical quantity between "Furniture" and "Office Supplies" on a chart. They are simply separate headers.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
How Tableau Uses Discrete Fields
The primary function of a discrete blue pill is to create labels or headers. When you drag a discrete field onto the Rows or Columns shelf, Tableau creates a distinct header for each member in that field. It slices up your view.
For example, if you place the discrete Category field on the Rows shelf, Tableau will create three distinct rows: one for 'Furniture', one for 'Office Supplies', and one for 'Technology'. It separates your data into these three buckets.
Fields that are text-based or categorical are almost always treated as discrete by default in Tableau.
Understanding Continuous Fields (The Green Pills)
Green pills are for data that can be measured along a continuous scale. The values are numerical and can, in theory, be broken down into infinitely smaller units.
What Makes Data Continuous?
Data is continuous if its values exist in an unbroken range. It’s something you measure, not something you count.
- Examples of Continuous Data: Sales figures ($100.51, $100.52, etc.), Temperature, someone's Age, or Profit amounts.
With each of these, there are countless possible values between any two points. Between a profit of $50 and $51, there's $50.10, $50.11, and so on. This continuous nature is what makes green pills suitable for creating axes.
How Tableau Uses Continuous Fields
The primary function of a continuous green pill is to create a quantitative axis. When you drag a continuous field onto the Rows or Columns shelf, Tableau creates a single axis that spans from the minimum to the maximum value of that data.
For example, if you place the continuous Sales field on the Rows shelf, you don't get a separate row for every single sales value. Instead, Tableau creates one vertical axis and plots marks along that axis corresponding to their sales value.
Number fields are typically treated as continuous by default.
Key Differences at a Glance: Blue vs. Green
Here’s a quick summary to help you remember the distinction:
- Color: Blue for discrete, Green for continuous.
- Function: Blue pills slice your data and create headers/labels. Green pills create a single quantitative axis.
- Data Type: Blue is for distinct categories (e.g., 'West Region', 'John Smith'). Green is for measurable numbers (e.g., 24.5 degrees, $9,999).
- Sorting: Discrete fields can be sorted alphabetically, manually, or by a measure. Continuous values sort along their axis naturally, from low to high.
- Filtering: Dragging a discrete pill to the filter card gives you a list of members to check on or off. Dragging a continuous pill gives you a slider to select a range of values. (More on this below!)
Putting It Into Practice: A Simple Chart Example
Let's use the sample Superstore dataset that comes with Tableau to see this in action.
Our goal: Create a simple bar chart to see total Sales for each Product Category.
- First, find the Category dimension in the data pane. This contains text values ('Furniture', 'Office Supplies', 'Technology'), so Tableau correctly identifies it as a discrete dimension.
- Drag Category onto the Columns shelf. You will see a blue pill appear and Tableau will create three separate column headers for your categories.
- Next, find the Sales measure. This contains numerical dollar amounts, so Tableau identifies it as a continuous measure.
- Drag Sales onto the Rows shelf. You'll see a green pill appear, and Tableau will create a single vertical axis. It automatically aggregates
SUM(Sales)and draws a bar chart, showing the total sales for each distinct category.
You’ve just used both data types as intended: the blue 'Category' pill sliced the view into columns, and the green 'Sales' pill drew an axis to measure the height of each bar.
The Special Case of Dates
Dates are one of the most common sources of confusion because they can be used as both discrete and continuous data, and Tableau gives you a choice.
When you drag a date field onto a shelf, you can right-click it (or right-click-drag it) to choose how you want to use it.
Discrete Dates (Blue Date Parts)
The top section of the date menu gives you discrete options, called date parts. Choosing YEAR(Order Date) as a discrete part will give you a blue pill.
This tells Tableau to treat each year as a separate category. If your data spans from 2021 to 2024, you will get four distinct headers: '2021', '2022', '2023', and '2024'. This is useful for comparing whole years against each other, like "Total sales in 2023 vs. 2024."
Continuous Dates (Green Date Values)
The bottom section of the menu gives you continuous options, called date values. Choosing YEAR(Order Date) from here will give you a green pill.
This tells Tableau to create a continuous axis of time. Even if you have no data for 2022, the axis will still show a space between 2021 and 2023. This is perfect for visualizing trends over an unbroken timeline, like a line chart showing sales growth month-over-month.
Think of it this way: discrete dates (blue) show categorical buckets of time, while continuous dates (green) show a flowing river of time.
How Discrete vs. Continuous Affects Your Filters
The difference between the two data types becomes incredibly clear when you use them as filters. It dramatically changes the user experience of a dashboard.
Discrete Filters: A List of Choices
When you drag a discrete field (like Region) onto the Filter card, Tableau prompts you with a list of all the members in that field ('Central', 'East', 'South', 'West'). You and your users can then check or uncheck the specific items you want to include or exclude from the view. This creates a list-based filter, like a multiple choice menu.
Free PDF · the crash course
AI Agents for Marketing Crash Course
Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.
Continuous Filters: A Range Slider
When you drag a continuous field (like Profit) to the Filter card, you get several options, but the most common is "Range of Values". This creates a filter with a slider. You and your users can then drag the handles to define a minimum and maximum profit to display, seeing everything that falls within that numerical range. This is great for filtering by a quantitative threshold.
Can You Switch Between Discrete and Continuous?
Yes, absolutely! Tableau makes an initial guess based on the data type (text, number, etc.) when you connect to a data source, but you are always in control.
You can change a field's default setting by right-clicking on it in the Data pane and choosing Convert to Discrete or Convert to Continuous. You can also change it on the fly in the view by right-clicking the pill on a shelf.
When would you do this?
A common example is with a numerical ID field like Order ID or a year. Tableau might see "2024" as a number and make it continuous. But you don't want to sum up order IDs or average them. You just want to count them as distinct items. In that case, you'd convert it to discrete, turning it from a green measure into a blue dimension.
By making it discrete, you tell Tableau to treat each ID number as a unique label instead of a value on an axis.
Final Thoughts
Getting comfortable with the difference between discrete and continuous data is a huge step toward becoming proficient in Tableau. Just remember that blue pills create individual labels and headers that chop up your view, while green pills create quantitative axes for measuring your data.
As powerful as this is, we know that tools like Tableau still come with a steep learning curve. The whole process of connecting data, understanding its structure, and then figuring out how to visualize it can take hours, even after you’ve grasped core concepts. With Graphed , we remove all that friction. You don't need to worry about whether a field is discrete or continuous, you just connect your data sources and ask questions like "Show me sales by product category" or "What's our profit trend over the last two years?" while we instantly build the interactive visualization for you.
Related Articles
Facebook Ads For DJs: The Complete 2026 Strategy Guide
Learn how to effectively use Facebook and Instagram ads to book more DJ gigs, attract event clients, and grow your mobile DJ business in 2026.
Facebook Ads For Jewelers: The Complete 2026 Strategy Guide
Learn how to run profitable Facebook ads for jewelers in 2026. Discover targeting strategies, visual best practices, and optimization tips to grow your jewelry business.
Facebook Ads for Pressure Washing: The Complete 2026 Strategy Guide
Learn the proven Facebook advertising strategies for pressure washing businesses in 2026. Generate more leads with targeted campaigns, compelling creatives, and proper follow-up systems.