---
schema_version: "1"
id: 5b5dd4204fa0f66b9f343b2ef8b1dfe514cb1304055b14bfe0a11415b31288df
title: Change the Sort Order
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_sort.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_sort.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b27343b1a9af415ca0413baa67a62358aa9ddaaedb3199c3769c5ff2645633d1
description: Choose whether data in your chart visualization is sorted ascending, sorted descending, or unsorted.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Change the Sort Order

Choose whether data in your chart visualization is sorted ascending, sorted descending, or unsorted.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in Salesforce Classic and Lightning Experience.</td></tr><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available with CRM Analytics, which is available for an extra cost in <strong>Enterprise</strong>, <strong>Performance</strong>, and <strong>Unlimited</strong> Editions. Also available in <strong>Developer</strong> Edition.</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
          <colgroup>
            <col style="width:50%">
            <col style="width:50%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d61999e72">User Permissions Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d61999e72 ">To view visualizations:</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d61999e72 ">Use CRM Analytics</td>

            </tr>
          </tbody>
        </table>

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note Sorting isn’t supported on measures in pivot tables.

1. Click the actions menu for the measure you want to sort. For dimensions, click the actions menu in chart, compare table, or pivot table mode.
    
    ![Analytics horizontal stacked bar chart with measure action menu showing sort options](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_sort_data.png)
2. Select **Sort descending** or **Sort ascending**.
    
    If the measure or dimension is already sorted, you can unsort it by selecting **Clear sort**.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note To show consistency across multiple bars in stacked charts, the stacked segments are always sorted alphabetically within each bar. Stacked charts include stacked bar, stacked column, stacked pyramid, and stacked waterfall. To help you locate a segment in a bar, the legend uses the same sort order as the bar segments.

![The bar segments and legend are sorted alphabetically.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_charts_stacked_chart_segment_sorting.png)

#### See Also

- [_Salesforce Help:_ CRM Analytics Quick Sort Limitations](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_quick_sort_ltd.htm&release=264.0.0&type=5 "CRM Analytics offers a powerful quick sort feature, enabling users to sort data directly within table and chart widgets by clicking column headers. However, some query configurations can interfere with this functionality. This document outlines known limitations and provides best practices for effective use of the quick sort feature.")
- [Tips for Working with SAQL Queries in the Query Editor](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_step_saql_limitations.htm&release=264.0.0&type=5 "Queries created or edited in the query editor have unique characteristics compared to other queries, like those queries created in the lens. Review the following tips for working with queries created in the query editor.")