What Is a Tableau Set? Custom Subsets of Dimension Members

A Tableau set is a custom subset of dimension members — a defined collection of marks from a dimension that can be used across views to create in/out comparisons and consistent analytical segmentation. Where a filter removes non-selected members from the view entirely, a set preserves all members but distinguishes between those inside the set (In) and those outside it (Out).

Sets answer the question "how does this defined group compare to everything else?" A filter answers "show me only this group." The analytical use cases are different.

Three Ways to Create a Set

**Manual selection:** Right-click selected marks on a view and choose "Create Set." The set contains exactly the members you selected. Useful for ad hoc analysis — selecting the top performing accounts you identified manually or isolating a specific product cohort.

**Condition-based set:** Define a set using a formula or field-based condition. A "High Value Customers" set might be defined as customers where SUM([Revenue]) > 500,000. Every customer meeting this condition is In the set; others are Out. Condition-based sets are dynamic — they update as the underlying data changes, recalculating which customers exceed the threshold.

**Top N set:** Define a set as the top or bottom N members by a measure. "Top 10 Customers by Revenue" is a Top N set containing whichever 10 customers have the highest revenue in the current data. Top N sets are also dynamic — the set members change as data changes.

Using Sets in Views

Once created, a set appears in the Data pane under "Sets." It can be dragged to any shelf like a dimension — to Columns, Rows, Color, or Filter.

**Set on Color:** Creates an in/out comparison encoding — all bars, points, or lines colored by whether they are inside or outside the set. Typically two colors (In = highlighted, Out = muted). This is the canonical set usage: a bar chart of all customers, colored to distinguish the high-value set from the rest.

**Set on Filter:** Applies the set as a filter, showing only In members. Functionally equivalent to a filter for this purpose; set-based filtering has the advantage of being reusable across multiple sheets with a consistent definition.

**Set on Rows or Columns:** The set dimension appears with two values (In, Out), creating a comparative split: a bar chart with an In bar and an Out bar for each category, enabling explicit side-by-side comparison.

Combined Sets

Tableau allows combining two existing sets using set operations:

**Union:** A member is in the combined set if it is in either of the source sets (logical OR)

**Intersection:** A member is in the combined set only if it is in both source sets (logical AND)

**Difference:** A member is in the combined set if it is in the first set but not the second (logical subtraction)

Combined sets enable sophisticated segmentation. A "High Value AND Recent" set might be the intersection of "Customers with Revenue > 500K" and "Customers with Last Order within 90 Days" — identifying the subset that is both high-value and currently active.

Set Actions (Tableau 2018.3+)

Set actions allow user interactions to dynamically update the membership of a set. Clicking or selecting marks in a view adds or removes those members from the set, and all sheets using that set update accordingly.

This enables powerful interactive analysis: a user selects specific customers from a scatter plot, and a summary bar chart immediately shows the aggregate metrics for just those selected customers versus everyone else. The set is the bridge between the user selection and the comparative view.

Set actions are defined in the dashboard's Actions configuration — source sheet, target set, behavior on selection, and what happens when the selection is cleared (keep set members, remove all members from set, or add all members to set).

Sets vs Groups vs Filters

These three mechanisms can appear to overlap:

**Groups** are static groupings of dimension members under custom labels — combining "Northeast" and "Mid-Atlantic" into "Eastern Region." Groups are renamed and reorganized members; the grouping does not change automatically.

**Sets** are membership definitions based on conditions or selection. Members can be In or Out; the set itself is a binary comparison mechanism. Sets update with data (for condition/top N sets).

**Filters** remove non-selected members from the view. Sets preserve all members but distinguish In from Out.

Choose sets when the analytical goal requires comparison between a defined cohort and everything else. Choose filters when the goal is to focus on a subset without the comparative context.

Our Tableau consulting services include advanced Tableau development — sets, parameters, and complex interactive design for analytical dashboards. Contact us to discuss your Tableau requirements.

A former Microsoft data architect audits your data foundation, identifies your top priorities, and sends you a written plan. Free. No pitch.