Reporting Matrix

Expert speak

Learn how Inforiver can be a smooth transition for Excel users to Power BI

Explore the numerous features in Inforiver that facilitate fast insights

Learn why Andre Fomin thinks Inforiver is in a league of its own

Deliver a financial statement in less than 5 minutes in Power BI, without using DAX

Rapidly deliver complex financial statements with no DAX knowledge

Overview

Deliver flexibility in layout, presentation and formatting for report developers

Deliver a range of charts inside your table/matrix reports in a single click

Enrich your decision-making by using no-code analysis & derivative calculations

Track changes to your report & data, and utilize notes to communicate context

Modern forecasting & dynamic simulation capabilities in a spreadsheet-like interface

General

Reorder and custom sort rows and columns in a few seconds, without resorting to DAX scripting or modelling workarounds

Leverage excel-like layouts such as classic, stepped & outline and show measures on rows or columns

With advanced filtering, filter values in each column as you can do in spreadsheets

Apply semantic formatting, color scales, segmentation, data bars and many more in a few clicks

Identify the most or least important categories using Inforiver's advanced Top/Bottom N + Others feature

Apply intelligent number formatting and scaling to your Power BI table/matrix reports

Edit font color, style, size, and text alignment in a cell, or apply formatting effects

Enhance your data stories with cell, row, column & report-level notes, footnotes & annotations

Manage row & column subtotals & grand totals the way you want in an intuitive & flexible manner

Leverage three types of quick-start business templates, each of which can be customized further

Build highly-formatted, interactive, no-code paginated reports in Power BI

Group specific rows or columns seamlessly in your Power BI table/matrix reports

Focus on relevant data when there are a large number of records using search and filter

Manage row and column hierarchies with options such as expand or collapse to specified levels, descendants and more

Filter rows, columns and measures, sort by name or value and highlight row/column hierarchies using rules or ranges

Experience an interactive, filterable, exportable and comment-enabled audit log to track changes to your report

Export your Power BI table/matrix reports to spreadsheets effortlessly

Inforiver delivers the measure management feature to manage comparative measures easily

Leverage Inforiver to add measures or columns with image URLs & display them as an image in your Power BI reports

Handle ragged hierarchies easily with Inforiver, without having to worry about blank rows

Formula & calculations

Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells

Insert static and calculated rows and enter values manually or define formulas using an intuitive excel-like editor

Add custom calculations as columns without having to create new DAX measures or calculated columns in the data table

Insert calculated measures when you have column hierarchies in your reports using Inforiver's advanced formula engine

Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group​

Display +/- signs in the table to indicate revenue or expense accounts and perform aggregations

Planning, budgeting & forecasting

Insert, edit and update values in your tabular reports​ with 50+ inbuilt functions, keywords and references

Allocate budgets and projections based on past performance or value drivers

Perform what-if simulations in Power BI using a graphical simulation slider

Report viewers can perform data input, simulations, 1-click variance analysis, notes, annotations and more

Graphical tables

Experience the fastest way to deliver insightful visualizations following IBCS standards

Show the distribution of data within a set of categories or groups with Inforiver's bar charts

Leverage lollipop charts instead of bar charts when there are a lot of categories

Show the breakdown of the total change in a value, such as a financial metric using waterfall charts

Compare the performance of two measures with Inforiver's bullet charts that come with six variants

Utilise six variants of 3-value bullet charts for comparing 3 measures seamlessly

Highlight distribution across categories or composition over time using Inforiver's stacked charts

Incorporate sparklines, spark columns, and their variants such as the win-loss trend to capture performance over time

Compare values across two segments or years using tornado charts

Incorporate multi-value KPI cards as part of your table/matrix reports

Blend two measures in a single column along with formatting, including conditional formatting

Conditional formatting

Highlight specific performance areas using one-click options such as quick rule, color scales, classifications, and data bars

Format positive and negative numbers using colors and indicate negative values with "-" or "()"

Apply color scales such as sequential, qualitative, diverging in a single-click

Apply formatting to entire rows or row headers, based on your requirements

Apply traffic light icons based on predefined ranges and customize icons/colors

Highlights values with circle fill and star rating icons based on ranges, with custom options

Perform analysis such as ABC analysis and create segments based on text, ratings or icon sets

Highlight top/bottom performers in reports with Inforiver's customizable conditional formatting

Apply different conditional formatting rules to different branches in a hierarchy

Learn to highlight different levels in a hierarchy based on rules without affecting totals

Highlight cells based on a dynamic cell selection

Easily apply conditional formatting based on IF conditions

Visual-level formulas

Use the spreadsheet-like formula bar to edit cell value or formula; supports formula references to other cells

Utilize the one-click options to insert columns such as % contribution to grand total, running total, ranking within group​

Perform one-click contribution and variance analysis without using DAX

Leverage no-code visual formula engine which supports 50+ functions (logical, math, boolean etc.,) and identifiers

Add custom calculations as columns and measures without having to create new DAX measures or calculated columns in the data table

Insert static, calculated, contribution and template rows in Power BI

Configure the column total and subtotal calculations when inserting calculated rows

Apply custom measure aggregations in a specific report (e.g., average quantity sold) instead of using the default aggregation

View absolute and percentage variances in a single-click by simply assigning the measures to the correct fields

Last updated