How to Change Bin Size in Tableau

Adjusting the bin size in Tableau is a simple way to get a clearer picture of your data's distribution. While Tableau’s automatic settings offer a good starting point, customizing the size of your bins allows you to fine-tune your analysis and uncover patterns you might otherwise miss. This article will walk you through exactly how to create bins, change their size, and even allow for dynamic adjustments directly on your dashboard.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What Are Bins in Tableau and Why Do They Matter?

In data visualization, a bin is a way to group a granular, continuous measure into a smaller number of "buckets" or intervals. Think of it like a set of containers for your data points. Instead of looking at every single unique value, you group similar values together.

For example, imagine you have sales data with hundreds of different transaction amounts: $12.50, $47.30, $8.99, $115.42, $23.10, and so on. Analyzing each individual value is overwhelming and doesn't tell you much about overall customer behavior. Bins solve this problem by grouping these values.

You could create bins with a "size" of $25. This would sort your data into groups like:

• $0 - $24.99
• $25 - $49.99
• $50 - $74.99
• $75 - $99.99

This simple act changes the data in a profound way. Your continuous measure (Sales) has now been converted into a discrete dimension (Sales (bin)) that you can use to build histograms, which are essential for understanding the distribution of your data. Bins help you answer questions like:

• What is the most common range for order values?
• Are most of our customers young, middle-aged, or older? (by binning customer age)
• Is shipping taking a few days, or are there significant delays? (by binning days to ship)

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Creating Bins Manually in Tableau (Step-by-Step)

While Tableau can automatically create bins when you select the histogram option from the "Show Me" panel, manually creating them gives you more control and is a foundational skill. It's the first step you'll need to master before you can change the bin size at will.

Let's use the Sample - Superstore dataset that comes with Tableau as an example. We'll create bins for the Sales measure.

1. In the Data pane on the left side, locate the continuous measure you want to group. In our case, this is Sales. You'll notice it's green, indicating it's a continuous field.
2. Right-click on the Sales measure. From the context menu, select Create → Bins....
3. The Create Bins dialog box will now appear. Here you have a few options to configure:
4. Click OK. You've now created your bin field!

You will now see a new field in your Data pane called Sales (bin) under the Dimensions section. Notice that it has a unique histogram-like icon next to it and is blue, indicating it's a discrete dimension. Your granular sales data is now neatly grouped and ready for use in a visualization.

How to Change the Bin Size for an Existing Bin Field

This is the most direct answer to the question. Once you've created a bin - either manually or by letting Tableau create it for you - modifying its size is incredibly straightforward. Often, the default or your initial guess for a bin size isn't quite right. Maybe the bars on your histogram are too wide (hiding detail) or too narrow (creating noise). Here’s how you fix it.

Let's say our bins of $250 are too broad and we want to see a more granular distribution.

1. Go back to the Data pane and find your bin field, Sales (bin).
2. Right-click on the Sales (bin) dimension.
3. From the menu, select Edit.... This will reopen the bin configuration window.
4. In the Size of bins field, simply type in a new number. Let's change it from 250 to 100 to create smaller, more numerous groups.
5. Click OK.

That's it! Any worksheet or dashboard using that bin field will immediately update. Your histogram will redraw itself with the new bins, allowing you to see if a size of 100 reveals a more useful pattern in the distribution of your sales data.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Using Parameters for Dynamic, User-Controlled Bin Sizes

Constantly editing a bin to test different sizes can become tedious. A much more powerful and flexible approach is to use a parameter to control the bin size. This lets you, or anyone viewing your dashboard, change the bin size interactively with a slider or a text box, without ever having to go into edit mode. This is a game-changer for data exploration.

Here’s how to set it up.

Step 1: Create the Parameter

First, we need to create the parameter control that the user will interact with.

1. In the Data pane, right-click on a blank area and select Create Parameter....
2. In the Create Parameter window, configure the following settings:
3. Under Range of values, set the limits for your users.
4. Click OK. You'll now see your new parameter at the bottom of the Data pane, in the Parameters section.

Step 2: Connect the Parameter to Your Bin Field

Now, you need to tell the Sales (bin) field to listen to the parameter instead of using a fixed size.

1. Find and right-click your Sales (bin) field in the dimensions list and select Edit....
2. In the Edit Bins dialog, look at the Size of bins input. Instead of a fixed number, click the dropdown arrow to its right.
3. You should see your newly created parameter, Select Bin Size, in the list. Select it.
4. The input box will now show the parameter name. Click OK.

Step 3: Show the Parameter Control on Your Worksheet

The final step is to make the control visible so you can start interacting with it.

1. In the Parameters section of the Data pane, right-click on your Select Bin Size parameter.
2. Select Show Parameter.

A control card will now appear on the right side of your worksheet viewport, likely as a slider. Try dragging the slider from left to right. As you do, you'll see your histogram redraw itself in real-time, instantly adjusting the analysis based on the bin size you've selected. You have just created a fully interactive histogram!

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Tips for Choosing the "Right" Bin Size

Now that you know how to change the bin size, the inevitable question is: what size should you choose? There is no single "correct" answer, it depends entirely on your data and the story you're trying to tell.

• A bin size that is too large can hide meaning. Imagine analyzing customer ages in just two bins: 0-50 and 51-100. You'd lose all the interesting details about different generations and life stages.
• A bin size that is too small can create noise. If your bins are too narrow (e.g., a size of $1 for your sales data), your histogram will have so many bars that it will be impossible to see the underlying shape of the distribution. It will look less like a pattern and more like random spikes.

The goal is to find a balance that smooths out insignificant irregularities while preserving the true shape of your data's distribution. The dynamic parameter you just built is your best tool for this. Play with it until the visualization tells a clear, compelling story about your data.

Final Thoughts

Mastering bins in Tableau - from creation to manual editing to making them interactive with parameters - gives you a much deeper level of control over your data analysis. It allows you to move beyond default settings and truly explore the distribution of your key metrics, leading to more nuanced and valuable insights.

We designed Graphed to dramatically accelerate this initial process of connecting data and getting to the insights. Instead of manually configuring bins and building histograms button-by-button, you can simply connect your data sources (like Google Analytics, Shopify, or Salesforce) and ask in plain English: "Show me a histogram of our Shopify order values from last quarter." We instantly generate the live, interactive visualization for you, correctly binned and ready for analysis, getting you from raw data to a clear answer in seconds.