Creating bins in Tableau - Complete Walkthrough

Introduction

Creating bins in Tableau helps you group continuous numbers into equal-sized segments. This makes it easier to analyze data by ranges instead of individual values.

When you want to group ages into ranges like 0-10, 11-20, etc., for better visualization.

When sales amounts need to be categorized into small, medium, and large bins for comparison.

When you want to create a histogram to see the distribution of a numeric field.

When you want to simplify a detailed numeric field into manageable groups for dashboards.

When you want to segment continuous data to spot trends or patterns more clearly.

Steps

Step 1: Right-click the numeric field you want to bin

- Data pane

A context menu appears with options related to the field

Step 2: Select 'Create' then click 'Bins...'

- Context menu

The Create Bins dialog box opens

Step 3: Enter the desired bin size number

- Create Bins dialog box in the 'Size of bins' field

The bin size is set, determining the range of each bin

Step 4: Click 'OK'

- Create Bins dialog box

A new bin field appears in the Data pane with the suffix '(bin)'

Step 5: Drag the new bin field to Rows or Columns shelf

- Worksheet view

The data is grouped into bins and displayed as a histogram or grouped chart

Before vs After

Before

Data pane shows a continuous numeric field 'Sales' with individual values like 100, 150, 200, 250

After

Data pane shows a new field 'Sales (bin)' grouping sales into ranges like 100-199, 200-299

Settings Reference

Size of bins

📍 Create Bins dialog box

Defines the width of each bin range

Default: 1

Common Mistakes

Setting bin size too large

Bins become too broad and hide important details in data distribution

Choose a smaller bin size to capture more detail and meaningful groups

Trying to create bins on a non-numeric field

Bins only work on continuous numeric fields, not categorical or text fields

Ensure the field is numeric and continuous before creating bins

Summary

Bins group continuous numbers into equal-sized ranges for easier analysis.

You create bins by right-clicking a numeric field and setting the bin size.

Bins help visualize data distribution and simplify numeric data into groups.