Sorting data
Last updated
Last updated
Inforiver provides the standard sorting options -ascending/descending or native power BI sorting. You can sort based on measures, variances, or axis values. In small multiples mode, you can also sort the panels in a specific order. The card section shows sorting based on the small multiples parameter.
1.1. Measure-based sorting: The chart below demonstrates how we can sort the bars by the Plan measure in ascending order.
1.2. Axis-based sorting: The chart below depicts how we can sort based on Axis categories.
1.3. Variance-based sorting: You can sort data based on the relative or absolute variance. In this chart, we've sorted the bars based on the relative variance.
For breakdown waterfall charts, you can sort the breakdown categories.
1.4. Panel sorting in trellis mode: You can sort the trellis panels based on the measure values or the small multiples parameter. In this example, we've sorted the panels based on the small multiples parameter - Subregion.
1.5. Stack sorting: When it comes to stacked charts, you can sort by the name or values of the stack/legend field or the aggregated measure value for each group category.
Stack value: The stacks within each bar are sorted in ascending or descending order based on the value.
Group: The stacks within each bar are sorted in alphabetical order based on the category name.
Measure value: The stack values are aggregated across axis categories and stacks are sorted based on the total value. Let's look at the data in the summary table to understand how this works.
Based on the summed-up data values, the stacks would be sorted in the order South < Central < West < East.
All the sorting options discussed in the charts section: measure/axis/variance/trellis sorting can be used in card mode.
The card mode is most often used with a small multiple parameter. When you add a small multiples parameter, the sorting interface has an additional group tab. You can sort the panels based on the measures or the dimension categories of the small multiples parameter. In the example, we have sorted the panels by the Actuals measure in ascending order.
In the second example, we've sorted the panels by the group dimension (Subcategory) and the individual charts by Actuals.
Measure-based sorting: When you sort tables based on a measure, an arrow icon is displayed near the column used for sorting. We have sorted the table in the example by the AC measure.
For tables, you can also sort data based on a measure directly from the column gripper.
Axis-based sorting: You can sort the rows in a table based on the axis values as demonstrated below.
Variance-based sorting: Inforiver provides the option of sorting rows based on the absolute or relative variance. We've sorted the data based on the relative variance in this example.
Sorting trellis panels: You can perform a multi-dimensional sort when you have row and column dimensions as small multiple parameters.
In the example, we've applied sort options for rows, columns, and data:
Axis: The rows in each table are sorted based on the values in the AC column.
Row: The trellis rows (Subcategory dimension) are sorted based on the row dimension categories.
Column: The trellis columns are sorted based on the overall AC value for each panel.
You can retain the sort order defined in Power by selecting the 'Native' option. The power BI sort order will be overridden when you select a different sorting method within Analytics+.
