Sorting data

Sort chart data to control the order in which values appear and improve readability. Use sorting options to reorder data and focus on the most relevant insights.

Why sorting is important in dashboards

Sorting brings the most important items (highest, lowest, fastest-growing) to the top

• Ordered data enables fast comparisons; differences between items are highlighted.

• Sorting makes it easier to spot extremes, anomalies, or clusters

Sorting based on measures

Order chart data by values with measure-based sorting, making it easier to highlight trends, rankings, and top or bottom performers.

Choose the measure to sort the data on. In this case, the bars are arranged in ascending order based on the selected measure

Axis-based sorting

Sort data based on axis categories, enabling comparison across data points. In this example, the order of bars is rendered based on the axis labels.

Variance-based sorting

Select the variance measure from By to identify categories with the highest variance.

In breakdown waterfall charts, you can sort breakdown categories by magnitude to clearly highlight the largest positive and negative contributors.

Sort breakdown categories in ascending order:

Sort breakdown categories in descending order

Sorting trellis panels

Use the Group tab to arrange trellis panels based on the total measure, variance, or group dimension category values.

Trellis panels arranged in alphabetical order of group dimension category:

Trellis panels arranged by measure value - in this case, the AC metric.