Sort & reorder data

Inforiver provides the standard sorting options - ascending/descending and A->Z/Z->A for numeric and non-numeric columns such as date, dropdown, text and more. Custom sorting orders can also be created using the drag-and-drop reorder feature.

1. Sorting

a) To sort a column by ascending or descending, hover over the column header and click on the gripper as highlighted.

Sorting by values

b) Select 'Sort' -> 'Sort desc' as shown.

Sorting by values descending

c) You can see that the column gets sorted and there is an icon to denote the descending sort.

Column sorted in descending order

d) To remove the sort, click on 'Remove sort' as shown. Alternatively, you can click on the sort icon in the header to remove the sort.

Removing sort

e) Similarly, sorting can also be applied to non-numeric columns. In a later section, we'll be covering how to insert data input columns such as text, dropdown, date etc.

Sorting non-numeric columns

f) On clicking the gripper near the column header, you can find the sorting options.

Sorting a dropdown column

g) You can see that the dropdown column is sorted in ascending order both at the region and sub-region levels.

Single-select column gets sorted

h) Sorting based on text and date columns is shown below.

Sorting a text column

Sorting a date column

2. Reordering

With Inforiver, you can custom-sort rows/columns by simply dragging and dropping to order the categories the way you want.

i) Rows

a) As you hover over a row header, you can see a gripper icon highlighted below. Click, hold and move up or down to reorder.

Reorder rows

Reordering is possible only within the same hierarchy level.

b) The rows are reordered.

Rows reordered

ii) Columns

Similarly, you can reorder columns and measures. Let's reorder the % variance.

a) Click on the column gripper by hovering over the column header.

Reorder measures

b) Drag and drop where required. You can see that the measure is reordered as shown below.

Measure reordered

c) Another way to reorder columns/measures is through the 'Manage columns' dropdown. Hover over the column/measure you want to reorder and simply drag and drop.

Reordering using manage columns

d) Instead, you can also click on the settings icon highlighted.

Manage columns settings

e) In the manage columns settings panel, hover over the six dots and use it to drag and reorder.

Reordering in manage columns settings panel

Unlike visual measures, visual columns cannot be re-ordered.

In the next section, we'll cover how to show/hide values, rows, and columns.

References

Custom sort / reorder rows & columns in Power BI