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.
- On a canvas page, select a chart and from the action menu (
-
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.