Sorting and Top N
Last updated
Last updated
The Innofalls Chart offer you the possibility to sort the elements in a chart. You can specify by which measure and/or dimension the chart should be sorted by. You can also sort by deviations to quickly identify elements with the largest impact.
You can activate sorting by either clicking on a axis label
When Top/Bottom N is active, you can also click the Rest label to open the settings dialog.
When more than one measure or additional deviation charts are available in the visual, you can choose by which measure to sort by.
When the Stack / Columns field contains a dimension, you can select which member to sort by.
None | No sorting; the sort order given by Power BI is applied |
Up | Sorts the values with the lowest value first by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available |
Down | Sorts the values with the highest value first by the specified sort measure. If only one measure is present in the chart, that one is taken and no measure choices are available |
You can apply this option, if you wish to limit the amount of elements shown in the chart. When this constraint is active, the N number of elements with the highest (top) or lowest (bottom) values are shown and all other elements are summarized in a rest member.
You can either specify a fixed number of elements to keep or you can choose one of the Auto settings to determine the number of elements to keep automatically. Auto is a good choice for responsive reports (e.g. mobile reports). The smaller the visual, the fewer elements are visible.
If the number of elements present is less than the constraint N, no Rest is generated.
You can rename the Rest member in the property pane under Sorting + Top N.
None | No Top / Bottom N is applied |
Auto Top | Keep top elements. The amount of elements is determined by the size of the visual. |
Auto Bottom | Keep bottom elements. The amount of elements is determined by the size of the visual. |
Top | Keep top elements specified by N. |
Bottom | Keep bottom elements specified by N. |
or by clicking the Sort and Top N button in the navigation menu.
