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.
