Filtering data by rank

Filtering data by rank focuses a visualization on a specified number of data points with the highest or lowest values.

  1. On the Chart Canvas toolbar, select the Add or edit a ranking by measure icon.
  2. In the Ranking dialog, select the measure to rank.
  3. Select Top or Bottom as the focus of the ranking.
  4. Choose the number of results to display.
    The default number is three.
  5. Select (ALL) to rank data based on all dimensions, or select the dimension to rank data on.
    For example, if a chart shows Sales Revenue by Country and Product Line, ranking the top five data points by Country shows data for each product line in the five countries with the highest sales revenue.
  6. Select OK.
The data is filtered by rank and a token representing the filter is added above the Chart Canvas. Only one ranking can be applied to a visualization at a time.