Control which members are displayed in a slicer.

For example, you can sort the elements of a slicer showing Customers so that they look ordered in alphabetical order.

  1. Right-click on the slicer and select Edit.
  2. Select the Advanced tab and then choose Sort Result.
  3. On the dropdown, sort by Member name
  4. Select Sort Ascending(A-Z) and then OK.

The members in the slicer will now be displayed in alphabetical order.