You can sort measures and dimensions in tables and charts in ascending or descending order, or you can set your own custom order for dimensions.
Setting a custom sort order is available only in Edit mode, but once set, it can be applied in View mode.
You can sort on multiple dimensions within the chart, but you cannot sort on dimensions and measures together and you can only sort on one measure at a time. However, when you have multiple dimensions in your chart, you can apply ranking to one dimension and sorting to another.
Watch this video to learn how to apply custom and advanced sorting.
Use Break Grouping when there are multiple dimensions in your chart. If Break Grouping is enabled, the sort will be applied to the selected data on the inner dimension and those dimension members will not remain in their original groupings. If Break Grouping is not enabled, the sort is performed on the outer dimension first and then inner dimensions.
Break Grouping On
In the following figure, the chart literally sorts the Gross Margin values, not keeping them in their respective Region groupings.
Break Grouping Off
In the following figure, the chart has the Break Grouping setting turned off, so the Gross Margin values are sorted within their Region groupings.