Sorting dimensions by occurrence on the Measures and Dimensions panel

You can sort dimensions visible in the Measures and Dimensions panel by the number of times each dimension value occurs in a dataset.

Sorting dimensions does not affect the data displayed in a visualization.

  1. Select the Horizontal Orientation icon on the Measures and Dimensions panel.
  2. Display the number of occurrences:
    1. Position the pointer over the dimension to filter.
    2. Select the Options gear icon, and select Show Measure and Occurrences.
    The number of occurrences appears beside each dimension value in the column.
  3. Sort by occurrence:
    1. Position the pointer over the dimension that you selected in step 2.
    2. Select the Options gear icon, and select Sort by Measure Lowest to Highest or Sort by Measure Highest to Lowest.
Data in the dimension column is sorted by occurrence.