Use the new advanced selector widget to synchronize members

The new Advanced selector widget supports one-way synchronization and has multiple selectors with the same hierarchy that lets you pick members from different groups to form a set. This new feature lets you easily compare members, view data for a range of members, or create a multiple selection list.

Advanced selector widget in a book

When you enable Synchronize hierarchies for a view or visualization, selecting a specific member in an Advanced selector updates the view or visualization. Changes in the Advanced selector widget trigger synchronization in the same synchronization group but does not synchronize to the changes of sets.

At any time, you can click Undo to reverse a selection change.

Adding an Advanced selector widget

You can add Advanced selector widgets from an exploration row, column, or context area but not from benched dimensions.

  1. In Edit mode, click the menu icon next to the dimension you want to create an advanced selector widget from.
  2. Under Add widget as, select Advanced selector.

After you add an Advanced selector widget to your book, you can customize the widget in its appearance, layout, selection methods, and choose when selection changes apply to the synchronization group.

Custom properties of an advanced selector widget

You can tailor the Advanced selector widget for your purposes.

Custom properties for an advanced selector
Apply selections

You can toggle if the change in one selection applies to its synchronization group immediately or changes from multiple selectors apply in a batch. Enable the In batch property if you want changes from multiple selectors to apply in a batch and only when the Apply button in the widget is pressed. Otherwise, any change in a member selection applies as soon as the change occurs.

Select Show as range selector if you want to see a range of members. The two selected members in the Advanced selector act as the first and last members of the member list and displays all the members between the two selections.
Important: The Show as range selector property works only when you have a maximum of two selectors in an Advanced selector widget.

In the following example, both the In batch and Show as range selector properties are enabled. When you change the member selections to 2 Quarter and 4 Quarter in the first and second selectors, the view updates to display all the members between 2 Quarter and 4 Quarter.

Range selection synchronization in Advanced selectors
Enable Multiple selection list to display the Advanced selector widget as a list, which allows multiple member selections.
Note: You will need to also enable the In batch property when using Multiple selection list so that changes apply after all the selections are made.
Layout
In the Layout section, you can select whether you want the Advanced selector to display horizontally or vertically and you can restore the widget to its default size.
You can also select the number of selectors that display in an Advanced selector widget. You can choose between two to four selectors. By default, Advanced selector widgets contain two selectors.
Selector titles
You can specify the title for each selector in an Advanced selector widget.
Selector style
Much like the custom properties of the Selector widget, under the Selector style section, you can display an Advanced selector widget as a simple list, expand and collapse the widget, show the search bar, and much more.