Sorting Measures and Dimensions

You can sort measures and dimensions in charts in ascending or descending order, or you can set your own custom order.

Context

You can specify the sort order for data in your chart for measures and dimensions: alphabetical ascending or descending, highest to lowest, and so on. You can even sort on multiple dimensions within the chart.

Note

While you can sort your data on multiple dimensions, you can't sort on dimensions and measures together, and you can only sort on one measure at a time.

Sometimes neither ascending or descending (or highest to lowest) sort will give you the results that you want.

Example

You have a chart that you would like to sort in the following way:

Very High
High
Medium
Low

Use Add Custom Order to rearrange the members as desired.

Procedure

Create a sort in one of these ways:
- On a canvas page, select a chart and from the action menu () select Sort.
- On a grid page, in the Examine panel at the bottom of the page select (More), and then select Sort.
Select the measure or dimension you want to sort and then choose one of the following options:
- Direction: choose Ascending, Descending, Highest to Lowest, and so on.
- Add Custom Order: in the dialog box, rearrange the members into the desired order.
To sort on a measure that isn't included in the chart, select Advanced Sorting, and then choose a measure from the list.