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
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.
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