Select the sets that display in a dimension drop-down

Use the new Customize sets option in the new experience exploration (cube view) and visualizations to limit the number of sets that appear in a dimension drop-down. You can select up to 20 sets for a dimension.

Note: The Customize sets option does not limit the sets that you see in the set editor. You can still see the full list of sets in the set editor.
Customize sets window

To Customize sets in an exploration, click the context menu of a dimension in the Row or Column area. You cannot customize sets for dimensions in the Context area.

Customize sets option in the view context menu


You can move dimensions with customized sets between the Row, Column, and Context areas without losing the limited sets.

However, if you move a dimension with customized sets off the exploration and add it to the book as a widget, the limited list of sets is lost. You will see all the sets for that dimension in its drop-down.

You can also customize sets for dimensions in visualizations. Select the visualization in Edit mode and click Fields. Click the menu for the dimension you want to customize, and select Customize sets.

Customize sets option in field slot menu

You can switch between a visualization and an exploration (or vice versa) without losing any customized sets that you applied.

For more information, see Customize sets in dimension lists.