Notion databases let you group rows by a property, but when that property is a multi-select field, the default grouping behavior can be confusing. Each row that has multiple tags appears in every group associated with those tags, which creates duplicated rows across groups. You want a clean view where each tag group shows only the rows that contain that tag, and you want each tag to keep its own background color. This article explains how to configure a database view to group by a multi-select property and how to assign and preserve per-tag colors so the grouping remains visually clear.
Key Takeaways: Grouping a Notion Database by Multi-Select With Color
- Database view > Group option: Select the multi-select property to group rows by each tag value; rows with multiple tags appear in each matching group.
- Multi-select property > Edit options: Assign a unique color to each tag value before or after grouping; the color persists in grouped views and filtered views.
- View layout > Group by > Collapse empty groups: Toggle this option to hide tag groups that have no rows, keeping the view compact.
How Grouping Works With a Multi-Select Property in Notion
Notion’s database grouping feature organizes rows based on the values of a selected property. When you group by a multi-select property, Notion treats each individual tag as a separate group. A row that has two tags, for example “Urgent” and “Design”, appears in both the “Urgent” group and the “Design” group. This is by design — it allows you to see all rows that share a specific tag, even if those rows also belong to other groups.
The multi-select property itself stores tag names and their associated colors. Each tag can have a distinct background color that you set in the property editor. When you group by that property, the group header displays the tag name and its color. The rows inside the group do not inherit the tag color; only the tag bubble inside each row retains its color. This behavior is consistent across table, board, and gallery views.
You must have at least one multi-select property in your database before you can group by it. If your database uses a single-select property, convert it to multi-select by opening the property type menu and selecting “Multi-select”. All existing values become individual tags, and you can add new ones.
Steps to Group a Notion Database by Multi-Select With Per-Tag Color
Follow these instructions to create a grouped view that uses a multi-select property and preserves each tag’s color. The steps assume you already have a database with a multi-select column.
- Open the database view menu
Click the view name at the top left of the database, then select “+ Add a view” or click the current view name and choose “Duplicate” if you want to keep the original view unchanged. Name the new view something like “Grouped by Tags”. - Apply the Group option
Click the “…” (More) button in the top right of the database toolbar. From the dropdown, select “Group”. A panel appears on the right side of the screen. - Choose the multi-select property
In the Group panel, click the property selector and choose the multi-select column you want to group by. Notion immediately groups all rows by each tag value. Rows with no tag appear in a group labeled “No [Property Name]”. You can rename or hide this group later. - Assign colors to individual tags
If your tags do not already have colors, open the multi-select property editor. Click the property name in the database header, then select “Edit property”. In the property editor, you see a list of all tag values. Click the color dot next to a tag name and pick a color from the palette. Repeat for each tag. The colors update immediately in the grouped view headers and in the tag bubbles inside each row. - Collapse empty groups
In the Group panel, toggle “Collapse empty groups” to “On”. This hides any tag group that contains zero rows. The setting keeps your view tidy when you have many tags but only a few are in use. - Sort groups if needed
Still in the Group panel, use the “Sort” section to order the groups. You can sort by tag name (alphabetically) or by a different property such as “Count” to show the most populated groups first.
After completing these steps, each tag group header shows the tag name with its assigned background color. Rows that contain multiple tags appear in each relevant group. The tag bubbles inside the rows retain their individual colors regardless of which group the row is displayed in.
Common Issues When Grouping by Multi-Select and Their Fixes
Rows Appear in Multiple Groups and That Looks Wrong
This is the expected behavior for multi-select grouping. Each tag value creates its own group, and any row that has that tag shows up in that group. If you want each row to appear in only one group, change the property type to single-select. Single-select grouping places each row in exactly one group based on its single value. To convert, open the property menu, select “Single-select”, and confirm the conversion. Existing rows with multiple tags lose all but the first tag.
Tag Colors Are Not Showing in Group Headers
Group headers display the tag name with the color you set in the property editor. If the header appears in default gray, open the multi-select property editor and verify that a color is assigned to each tag. Click the color dot and select a new color, then click “Done”. The group header updates immediately. If the color still does not appear, refresh the page by pressing Ctrl+R or Cmd+R.
Grouped View Shows Duplicate Rows That Should Not Be Duplicated
A row with two tags appears in two groups, but the row itself is not duplicated in the database. The duplication is visual only. If you export the view, each row appears only once per export row, but the grouping is lost in the export. To see a flat list of all rows without grouping, switch to a table view that has no group applied.
Cannot Find the Group Option in the Database Toolbar
The Group option is available only in table, board, and gallery views. In a list view, you cannot group rows. Switch the view layout by clicking the view name and selecting “Table”, “Board”, or “Gallery”. Then the Group option appears in the “…” menu.
Notion Database View Grouping Options Compared
| Feature | Group by Single-Select | Group by Multi-Select |
|---|---|---|
| Row duplication across groups | No — each row appears in exactly one group | Yes — a row appears in every group whose tag it contains |
| Tag color in group header | Uses the single-select option color | Uses the multi-select tag color |
| Rows with no value | Grouped under “No [Property]” | Grouped under “No [Property]” |
| Sort groups by tag name | Available | Available |
| Collapse empty groups | Available | Available |
Choose single-select grouping when you need a strict one-group-per-row view. Choose multi-select grouping when you need to see all rows that share a specific tag, even if those rows belong to multiple categories.
You can now create a Notion database view grouped by a multi-select property where each tag keeps its own color. Start by adding a multi-select column to your database, assign colors to each tag, then apply the Group option from the view menu. For advanced filtering, combine the grouped view with a filter that shows only rows containing a specific tag — click “Filter” next to the view name and set the condition to “contains” the tag you want to isolate.