Hierarchy settings

The general display settings are used to customize the appearance of the report.

In the Inforiver toolbar, navigate to the Home ribbon. The Settings option is available in the 'Actions' section. Click Settings > Display Settings to open up the Display side panel.

Click on the Hierarchy tab in this panel to view the hierarchy settings.

Let's explore the options to customize hierarchies in your reports.

1. Header and Column

1.1. Category Highlight

This drop-down lets you show or hide the category highlight. This option is set to 'Off' by default. When this option is enabled, a color picker is displayed. You can select a color to highlight the category hierarchy.

1.2. Suppress Null Visual Columns

Columns containing null values will be suppressed if this option is enabled.

2. Data window

2.1. Data Volume

Inforiver supports wide table use cases through the dynamic columns feature. You can fetch up to 1000 columns, however, the performance would be compromised.

Every fetch from Power BI is 30,000 cells (No of rows x No of columns). This means you can load data chunks of different sizes dynamically - 500 Rows by 60 Columns (or) 30 Rows by 1000 Columns (or) 10,000 Rows by 3 Columns.

You can adjust this volume to retrieve more data from the data source.

Learn more about dynamically setting data chunk size using Power BI's fetchMoreData API.

3. Row totals

You can customize the grand total title and height here.

3.1. Grand total title

The options related to Grand total can be seen only if the Row/Column Grand Total value has not been set to ‘Off’ under the ‘Totals’ option.

You can set a custom title for the grand total in the textbox.

3.2. Grand total height

The value that you specify here will override the default height of the grand total row.

The minimum and maximum values for grand total height are 5 and 45 respectively.

Resources

Implementing tables with 100+ columns (wide tables) in Power BI

In this section, we covered the hierarchy display settings. Navigate to the next section to learn more about advanced number formatting.

Last updated