Comment on page

Sorting and Top N

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.
Sort and Top N Settings
​
You can activate sorting by either clicking on a axis label 
or by clicking the Sort and Top N 
button in the navigation menu. 
When Top/Bottom N is active, you can also click the Rest label to open the settings dialog.
Sorting
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.
Sort Options
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
Top / Bottom N
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.
Top / Bottom N Options
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.

Interactivity - Previous

Dynamic Deviation Charts

Next - Interactivity

Highlighting

Last modified 2mo ago

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

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.