Inforiver
FormulaPricingProductAll Products
Reporting & Writeback Matrix Docs
Reporting & Writeback Matrix Docs
  • Introduction to Inforiver
    • Why Inforiver
    • Get Started
      • Installing Inforiver for yourself
      • Installing from AppSource
      • Installing Inforiver for your organization (Org visual)
      • Inforiver Writeback Matrix pre-requisites
        • Whitelist Inforiver IPs
        • Admin consent for Inforiver's Entra ID
          • Basic consent
          • Full admin consent
      • Inforiver Customer Portal
        • Billing Admin
          • Update Profile
          • Update Subscriptions
        • License Admin
      • Licensing
        • License renewal
      • Registering Inforiver on Azure AD (Entra ID)
  • Working with Inforiver
    • 1. Build your first Inforiver report
    • 2. Displaying information
      • Report interface
      • Layout options
      • Templates
      • Basic formatting
        • Number formatting
        • Cell, header & value formatting
        • Totals & subtotals
        • Insert blank rows
      • Basic inline charts
    • 3. Basic interactions
      • Explore & filter data
        • Search & Filter
        • Explorer
        • Top N + others
      • Sort & reorder data
      • Show/hide values
      • Manage column widths
      • Manage hierarchies
      • Create visual hierarchies
      • Pin rows & columns
      • Blend measures
      • Dynamic measure headers
      • Context menus
        • Column gripper
        • Row gripper
      • Actions
        • Rails
        • Toolbar options
        • Keyboard shortcuts
        • Reset
    • 4. Adding business logic and formulae
      • Insert calculated rows
        • Template rows
      • Insert calculated columns
      • Insert manual input rows
      • Insert manual input columns
        • Number
        • Dropdown
          • Dropdown options from semantic models
          • Lookup visuals for dropdowns
        • Text, checkbox & date
        • Writeback Matrix features
      • Invert sign
      • Editing cells
      • Quick formula
      • Visual column inside visual measures
      • Manage inserted rows
      • Manage inserted measures & columns
      • Pivot data
      • Insert image URLs
    • 6. Working with charts
      • Sparkline charts
      • Stacked charts
      • Bullet charts and clustered bar charts
      • Waterfall charts
      • Bar and pin charts
      • Change/deviation charts
    • 5. Conditional formatting
      • One-click options
      • Create rule
        • Rules (If conditions)
        • Color scale & data bars
        • Classification
        • Ranking
      • Manage rules
    • 7. Planning, budgeting & forecasting
      • What-if analysis & simulations
      • Goal Seek
      • Scenarios (Writeback Matrix only)
      • Budgeting & allocations
      • Forecasting
        • Date rollover and extending forecasts
        • Editing forecasts and reforecasting
        • Autoclose forecasts
        • Distribute deficit
        • Row level forecast
        • User Access Control
        • Common Scenarios
          • Forecast using a Blank Template
          • Forecast using Existing Data
          • Adding Forecasts for Periods unavailable in the model
          • Creating daily and weekly forecasts
      • Set version
    • 8. Paginated reporting
      • Pagination
      • Header & footer
        • Text
        • Images
        • Charts
        • KPI cards
      • Report layouts (Report+)
      • Display and themes
    • 9. Commenting and collaboration
      • Notes
      • Comments
        • Data-level comments
        • Assign & track tasks
        • Track changes
        • Report-level comments
        • Comment settings
    • 10. Exporting reports
      • Export to PDF & Excel
        • Excel export - operational boundaries
      • Ad-hoc emails
      • Snapshot (Writeback Matrix only)
        • Comparing snapshots
    • 11. Scheduling reports
      • Create new subscription
        • Select a report
        • Set subscription frequency
        • Select destination(s)
          • Email
          • OneDrive
          • Microsoft Teams
          • SharePoint
        • Review & save subscription
      • Manage your subscriptions
      • Administration
    • 12. Data writeback
      • Settings
        • General Settings
        • Data Settings
        • Destination Settings
        • Writeback security settings
        • Writeback time-out & batch size settings
        • Advanced Settings
      • Destinations
        • Azure SQL (Managed DB)
        • Azure SQL
        • Microsoft SQL Server
        • Synapse Dedicated SQL Pool
        • Azure Data Lake Storage
        • Databricks
        • Snowflake
          • Setting up Snowflake OAuth
        • Amazon Redshift
        • BigQuery
        • SingleStore
        • SAP HANA
        • Oracle
        • PostgreSQL
        • MySQL
        • OneDrive
        • SharePoint
        • Dataverse
        • Fabric Warehouse
        • Fabric lakehouse
        • Fabric SQL
        • URL as destination
      • Logs
      • Reading mode
    • 13. Context awareness
    • 14. Manage aggregation
      • Row aggregation
      • Column aggregation
    • 15. Managing Inforiver Writeback Matrix visuals
      • Inforiver deployments in Power BI pipeline setup
      • Duplicating Writeback Matrix Visuals - Best Practices
      • Recommended practices while working with Power BI desktop
    • 16. Approval workflows
    • 17. Collaborative adjustment workflows
    • 18. Variables
      • Variable types
        • Number
        • Select
        • Text
        • Date
        • Date range
        • Boolean
        • Button
      • Variable bookmarks
    • 19. Leveraging Power BI bookmarks
  • Admin Console
    • Manage Profile
    • User management
      • User Roles and Permissions
      • Create custom roles and policies
    • Settings
      • General
      • Generate builds - on prem
      • Forecast
      • Holidays
      • API token
      • Writeback
      • Managed DB
      • Assets
    • Onboarding actions
    • Writeback
  • Display settings
    • General settings
    • Hierarchy settings
    • Number settings
    • Miscellaneous settings
    • On-load scripting
  • Formula syntax
    • Conditional statements
      • IF
      • IFNA
      • SWITCH
      • FILTERIF
    • Logical functions
      • AND
      • IN
      • ISBLANK
      • ISEMPTY
      • ISNUMBER
      • NOT
      • OR
      • XOR
    • Math functions
      • ABS
      • AVERAGE
      • AVERAGEEXNEG
      • AVERAGEEXZERO
      • AVERAGEEXZERONEG
      • AVERAGEIF
      • CEILING
      • COUNT
      • COUNTIF
      • DIVIDE
      • EVEN
      • EXP
      • FLOOR
      • INDEXOF
      • LOG
      • ODD
      • MAX
      • MIN
      • NORMDIST
      • NORMSDIST
      • NORMINV
      • NORMSINV
      • PCT
      • POWER
      • RAND
      • RANDBETWEEN
      • ROUND
      • SORT
      • SQRT
      • SUM
      • PMT
    • Text formatting functions
      • CONCATENATE
      • HYPERLINK
      • LEFT
      • LOWER
      • MID
      • PROPER
      • REPLACE
      • REPT
      • RIGHT
      • TEXT
      • TRIM
      • UPPER
      • VALUE
    • Date functions
      • DATEADD
      • DATEDIFF
      • DAY
      • DATE
      • DATE.SET
      • DATE.FORMAT
      • SOWEEK
      • SOMONTH
      • SOQTR
      • SOYEAR
      • EOWEEK
      • EOMONTH
      • EOQTR
      • EOYEAR
      • NETWORKDAYS
      • ADDDAYS
      • ADDWEEKS
      • ADDMONTHS
      • ADDQTRS
      • ADDYEARS
      • FROMEXCELDATE
      • MONTH
      • NOW
      • PERIOD_RANGE
      • TODAY
      • TOEXCELDATE
      • YEAR
    • Time intelligence functions
      • AGGREGATE
      • FILTER
      • COLUMN_PERIOD
      • LASTNDAY
      • LASTNMONTH
      • LASTNQTR
      • LASTNYEAR
      • MONTHPERIOD
      • MOVINGAVERAGE
      • MOVINGSUM
      • MTD
      • NEXTNDAY
      • NEXTNMONTH
      • NEXTNQTR
      • NEXTNYEAR
      • QTD
      • QTRPERIOD
      • SHIFT
      • TOTALYTD
      • TOTALQTD
      • TOTALMTD
      • VALUEAT
      • YEARPERIOD
      • YTD
    • Other operators
    • Identifiers
      • CLOSEDPERIOD
      • COLUMN.DATE
      • COLUMN.PARENT
      • COLUMNS
      • CURRENT_PERIOD
      • DESCENDANTS
      • FORECAST.CLOSED_END
      • FORECAST.CLOSED_START
      • FORECAST.OPEN_END
      • FORECAST.OPEN_START
      • GROUP INDEX
      • HAS
      • HAS_ALL
      • HAS_SOME
      • LEAVES
      • LEVEL
      • LOGGEDIN_EMAIL
      • LOGGEDIN_NAME
      • MATCH
      • MAXDATE
      • MEMBERS
      • MINDATE
      • RELATIVE
      • RELATIVE_COLUMN
      • ROW.PARENT
      • ROW.LABEL
    • Scripting functions
      • DISPLAYTOAST
      • EXPORT
      • LAYOUT
      • SETCFRULE
      • SETFILTER
      • SETFILTERBYINDEX
      • SETVISIBILITY
      • SHOWBETWEENPERIOD
      • SHOWCLOSEDFORECAST
      • TOPN
      • DISPLAY SETTINGS
        • SETBLANKLABEL
        • SETSUPPRESSZEROS
        • SETRAGGEDHIERARCHY
        • SEPARATOR
        • SETCOMBINECOLUMNHEADER
        • SEMANTICFORMAT
        • SHOWNULLAS
        • SHOWZEROAS
        • SINGLECHILD
    • Miscellaneous functions
      • FETCH
      • LOOKUP
    • Measure/Column selection functions
      • GETCOLBETWEENPERIODS
      • GETMEASURE
  • Advanced topics
    • Audit log
    • Backup & restore report config
    • Enterprise themes
    • PowerPoint integration
    • Drill down and roll up in performance mode
  • Infobridge
    • 1. Create bridge
    • 2. Add source to bridge
    • 3. Bridge Interface
    • 4. Manage queries
      • Query transformations
        • Append
        • Join
        • Duplicate
    • 4. Manage sources
    • 5. Insert rows from bridge
    • 6. Insert measure from bridge
    • 7. Manage Integration of visuals
    • 8. Manage Bridges
    • 9. Data transformations
      • Pivot table
      • Group by
      • Add Column
      • Pivot column
      • Rename column
      • Find and Replace
      • Remove measure
      • Filter rows
      • Sort
      • Text functions
      • Unnest
      • Round
      • Extract Comments
      • Import and export
    • 10. Integrating forecasts
    • 11. Collaborative adjustments
  • Accessibility shortcut keys
  • Inforiver Reporting Matrix FAQs
  • Inforiver Writeback Matrix FAQs
  • Video tutorials
  • Resources
  • Release Notes
    • Inforiver Writeback Matrix May 2025 - v4.4.3
    • Inforiver Writeback Matrix April 2025 - v4.4.2
    • Inforiver Writeback Matrix April 2025 - v4.4.
    • Inforiver Writeback Matrix March 2025 - v4.3 - Time series formulae
    • Inforiver Writeback Matrix - March 2025 - v4.2
    • Inforiver Writeback Matrix March 2025 - v4.1
    • Inforiver Reporting Matrix March 2025 - V3.3.3 -New formatting and export options
    • Inforiver Writeback Matrix Feb 2025 - v4.0 - User permissions, High-performance mode, Input rules
    • Inforiver Writeback Matrix January 2025 - v3.9 - Fabric support, upgraded variables interface
    • Inforiver Writeback Matrix December 2024- v3.8 - Improved Scheduler Performance & Other Enhancements
    • Inforiver Writeback Matrix December 2024 - v3.7 - Merge rows, new rounding functions & More
    • Inforiver Writeback Matrix November 2024 - v3.6.2 - Import from Google Sheets & More
    • Inforiver Writeback Matrix October 2024 - v3.6 - Approval Workflows & Other Enhancements
    • Inforiver Writeback Matrix October 2024 - v3.5 - Lookup visuals & more
    • Inforiver Reporting Matrix Nov 2024 - v3.3 - Variables
Powered by GitBook
On this page
  • 1. Header and Column
  • 2. Expand to level
  • 3. Mixed layout
  • 4. Child
  • 5. Data window
  • 6. Row totals
  • 7. Total API

Was this helpful?

  1. Display settings

Hierarchy settings

PreviousGeneral settingsNextNumber settings

Last updated 1 month ago

Was this helpful?

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

If this option is enabled, when the report canvas is resized to a small size, only columns that fit into the canvas will be displayed and others will be hidden.

In the image below, after resizing the canvas to a much smaller size, out of the 3 measures added in the report, only 2 measures that fit into the view are displayed. This is because the responsive columns option is enabled.

1.3. Show totals/subtotals values for non-numeric measures

You can add non-numeric measures like dates and text fields and display them in your reports. The first value is displayed in the total/subtotal cell by default, which may be irrelevant in an aggregated row. You can choose to leave the totals and subtotals blank for non-numeric fields by enabling this property.

1.4. Combine column headers

Enabling this option will combine the column headers and measure labels to display compact headers. As you can see from the below image, when this option is turned off, the column headers and measure labels are displayed separately.

When this option is enabled, the column headers and measure labels are combined and displayed compactly. If the Combine Column Header option is enabled, you can set a custom separator using the Column header separator option.

If the 'Combine column headers' option is enabled, you won't be able to reorder the columns.

Column header separator

This option lets you specify the separator that will get inserted between the column header and the measure label.

1.5. Ragged hierarchy

In the case of ragged/unbalanced hierarchies where the number of levels is uneven, you can hide the blank category rows.

Notice how the blank categories under 'IT Expenses' and 'Other Expenses' have been hidden after enabling the Ragged Hierarchy option.

On enabling ragged hierarchy, additional options are displayed:

  • Hide blanks

Using this option you can choose to hide the rows if the category is blank, values are blank or both value and category are blank.

If your reports contain rows that only have an Others measure but no actuals, you can choose to suppress that row. Navigate to Hierarchy Settings and set the Hide Blanks dropdown to ‘Visible Values’. When you select Ignore Measure in Null Suppression from the column gripper, notice how the highlighted row is hidden.

  • Suppress zeros

If you enable this option, then the rows containing zeros will be suppressed.

This option becomes available only if the option chosen in the Hide Blanks is 'Value' or 'Value+Category'.

  • Suppress null columns

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

  • Hide blank label columns

Columns with blank labels will be suppressed if this option is enabled.

  • Hide blank dimensions in column hierarchy

When you have hierarchical column dimensions, there may be cases where the entire dimension category is blank as shown in the report below.

Since these categories do not add value to the report, you can suppress them by enabling the Hide blank dimensions in column hierarchy option.

1.6. Row hierarchy icon

You can select custom icon styles to represent the row hierarchy i.e. choose the expand/collapse icons for hierarchical categories. If 'None' is selected, an icon will not be displayed.

1.7. Column hierarchy icon

You can select custom icon styles to represent the column hierarchy as well.

2. Expand to level

If your dataset contains hierarchies with multiple levels, you can choose to expand the hierarchy to a specific level at the initial load. This setting will be retained even after applying a filter/slicer.

3. Mixed layout

You can display a chosen field as a separate column similar to the stepped layout. By default, it is set to 'None'. In the below image, the 'Sub Category' field has been selected and it gets displayed as a separate column in the visual.

This option is available only in the Hierarchy layout when there are 3 or more levels in the row dimensions.

4. Child

4.1. Indent from parent

This option lets you set the amount of indentation that has to be applied to the child rows from the parent row.

The minimum and maximum indentation values are 1 and 25 respectively.

In the image below, every child row has been indented from its parent row by the specified amount.

4.2. Single child

Using this option you can select which nodes to display when a parent hierarchy has only one child. In this example, we have a multi-level account hierarchy with several single-child rows and blank rows.

The sales and marketing expenses row has only one child. The personnel cost row's child rows have blank rows. Let's see how this report is displayed for each of the options.

  • All - Displays all the rows i.e. the parent rows and the single child rows. There are blank rows at levels 5 and 6.

  • Parent only - Displays the parent nodes of the single child. The blank rows at level 6 have all been hidden as shown below. The blank rows at level 5 are still shown.

  • Parent (Multi-level) - Displays only the highest level row of the multi-level hierarchy. The blank rows at both levels 5 and 6 are not shown.

  • Single child level as parent - Displays the single child as the parent of its level.

Let's take a different scenario to explain the Single Child Level As Parent and Single Child As Parent options. As you can see below, under Operating expenses we have filtered only IT expenses. You can see blanks at levels 5 and 6.

On selecting Single Child Level As Parent, you can see that the level 6 blank row is shown as the child for the level 4 row.

  • Single child as parent - Displays only the single child at the lowest level. The blank row at level 6 is shown as the child for the level 3 row.

5. Data window

5.1. Max columns

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 view the current column count by hovering over the 'i' icon and modify the column count if needed.

6. Row totals

You can customize the totals and subtotals by adding child count, padding, border, editing titles, and more. The available options are explained below.

6.1. Show child count

Enabling this option will display the count of child rows next to the name of the parent row in brackets.

6.2. Show descendants count

You can also display the total number of children including the leaf nodes under a parent category.

Prerequisite: the Show Child Count option should be enabled.

6.3. Top padding

Using this option, you can configure the spacing/padding between row hierarchies.

6.4. Expand/collapse

This option lets you specify when the expand/collapse icons for the hierarchies have to be displayed.

  • Always present - Expand/collapse icon will be always present

  • Only on hover - The expand/collapse icons are displayed only when you hover over the rows

6.5. Hide hierarchy icon

With this option, you can specify the fields for which you want to hide the hierarchy icon. All the fields are selected by default, and unselecting any field will hide the hierarchy icon for that field. In the below image, the 'Sub Category' field has been unselected, therefore the hierarchy icon for that field has been hidden.

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

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

7. Total API

Inforiver pre-calculates the totals and subtotals for your data while loading the report. If your dataset is large and you do not require totals in your reports, you can substantially reduce the loading time of your report and boost its performance with the Total API option.

You can disable the total and sub-total calculations for rows and columns separately.

7.1. Row Total/Subtotal

Disable this to stop row-level total and sub-total calculations while loading your report.

7.2. Column Total/Subtotal

Disable this to stop column-level total and sub-total calculations while loading your report.

Notice the time taken when Inforiver pre-calculates the totals and subtotals:

When the total calculation is disabled, even large datasets can be fetched in milliseconds as shown in the screengrab below.

Resources

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

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

fetchMoreData API
Implementing tables with 100+ columns (wide tables) in Power BI
advanced number formatting
Hierarchy settings
Cateory highlight
Responsive columns
Report with responsive columns enabled
Non-numeric fields displayed as totals/subtotals
Totals/subtotals left blank for non-numeric fields
Combine column headers
Combine column headers
Ragged hierarchy option
Ragged hierarchy sub-options
Null suppression
Blank categories in the column dimension
Suppress blank categories in the column dimension
Row hierarchy icon
Change the expand and collapse icons
Expand to level
Mixed layout
Indent from parent
Single child - All
Single child - Parent only
Single child - Parent multi-level
Single child at level 4
Single child level as parent
Single child as parent
Column count
Show child count
Show descendants count
Top padding
Expand/Collapse icons
Hide hierarchy icon
Grand total title
Grand Total Height
Total API
When Totals are pre-calculated
After Disabling the Total API