Filtering data by rank focuses a visualization on a specified number of data points with
the highest or lowest values.
- On the Chart Canvas toolbar, select the Add or edit a ranking by
measure
icon.
- In the Ranking dialog, select the measure to rank.
- Select Top or Bottom as the focus of the
ranking.
- Choose the number of results to display.
The default number is three.
- 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.
- 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.