Inforiver

Upcoming webinar on 'Inforiver Charts : The fastest way to deliver stories in Power BI', Aug 29th , Monday, 10.30 AM CST.    Register Now

Inforiver Matrix December 2022 Update – Version 1.8

by Chandra Vadana Rajamohan | Dec 07, 2022 | ,

Welcome to the Inforiver Matrix December 2022 update. We are thrilled to announce several new features and key enhancements (for all the editions) most anticipated by our Inforiver community!   

Key enhancements in this v1.8 release are listed below. Feel free to jump to any specific section for more details. 

  1. Report level notes & rich text editor
  2. Data input types 
  3. Lock values during allocations and simulations 
  4. Data input and simulations in reading view 
  5. Dynamic report title based on slicer selection 
  6. 1-click empty row option for formatting and static value capture 
  7. Row header auto wrap 
  8. Transparent report background  
  9. Design tab enhancements
  10. Measure only highlight 
  11. Redesigned compact launch wizard 
  12. UX improvements for discoverability 

Inforiver’s notes capability has been revamped in the December version to include a lot of feature requests from customers. 

You can now enter notes in a larger screen and add numbered/bulleted lists, hyperlinks and apply rich formatting.

Enter notes

With Inforiver, you can also add notes and explanations at the report level as shown below. 

Report level notes

‘View all notes’ option enables you to view all the notes in the measure level notes in the report. 

View all notes

Inforiver also provides the ability to filter notes based on the Power BI filter selection. In the below image, filter Category to show only ‘Water’. The notes in Inforiver have been filtered accordingly. 

Note that the field that is to be filtered must be added as part of the Inforiver visual. 

2. Data input types 

The December release of Inforiver Matrix introduces support for manual data input columns – text, dropdown, check box and date (which were previously available only in Inforiver Enterprise) as well as the ability to offer these input fields for report readers/viewers which is explained below in point 3 – Data input and simulations in reading view.  

Data input types

It must be noted that for the below listed points, Inforiver Enterprise needs to be used. In Inforiver Matrix, these options are either greyed out or shown as warnings. 

  • Creating dropdown list of values from datasets is not supported 
  • Values modified in read mode will not be saved 
Single Select

Data input columns can be filtered using the nested AND/OR filter as shown below. 

3. Lock values during allocations and simulations 

Let’s consider a scenario – There is an overall budget for 2023 which is distributed to the regions based on 2022 Actuals. Certain regions and their sub-regions can have a fixed budget, and the budget has to be reallocated once these changes are made.  

This can be easily achieved using Inforiver Matrix as shown below. 

a) Insert a numeric data input column for 2023 Budget as shown below. Enter the budget 1.2b and distribute by 2022 Actuals. 

Enter the budget

b) Update the budgets for Pacific and Midwest and lock the cells.   

 lock the cells

c) The overall budget has increased to 1249.1m, let’s enter 1.2b again as the overall budget. The budgets get redistributed as shown below. 

Budgets get redistributed

You can also lock at the subtotal level which would freeze the values including all children using the ‘Lock all children’ option.  

Similarly, simulations can also be locked at a cell level. In the below example, Pacific is increased by 10% and locked.  

Simulation lock

When one of the sub categories – Juices, is updated to 7%, simulations for the other sub categories get adjusted to maintain the 10% increase for Pacific. 

4. Data input and simulations in reading view

With the Inforiver Premium Matrix 1.8 release, the report viewer would be able to derive a lot more value out of Inforiver. They can perform data input, simulations, 1-click variance analysis, notes, annotations and more which is explained in this video. Note that these changes can’t be saved, but it can be exported as an Excel and shared with other users. 

The ability to offer this insert capability - data input and simulate - can be turned on/off using the reading view access. 

Data input and simulations in reading view

5. Dynamic report title based on slicer selection

It is now possible to insert dynamic titles based on Power BI slicer selection. 

In this example, selections in the Brand Name and Product Category slicers are reflected in the Inforiver header. 

Dynamic title based on slicer selection

This can be achieved by using the highlighted preset and customizing as required. (Note: To obtain the header shown in the previous image, remove the report title and column members section.) 

Header preset

6. 1-click empty row option for formatting and static value capture 

You can now create and format financial statements and reports by adding white spaces as required using the insert empty row option.  

1-click empty row option for formatting

This is also very useful when used with the measure in rows option, as you can now easily insert empty rows and capture static values.  

7. Row header auto wrap 

Long row hierarchies can be wrapped automatically by enabling the ‘Auto wrap columns’ option as shown in the below image.  

Row header auto wrap 

To wrap the column header for the row hierarchy columns, enable the ‘Column header word wrap’ option. 

Column header word wrap

8. Transparent report background

On popular request, we have introduced support for transparent report background in v1.8. This means any image/background color that you use in your Power BI report gets reflected in the Inforiver visual as shown in the below image.   

Transparent report background

To apply an image background, in Display settings -> General, set ‘Canvas background’ as ‘No fill’ and ‘Row Highlight’ as ‘Off’. In the Power BI visualizations pane, add the image in Format page -> Canvas background. 

9. Design tab enhancements 

Frequently used options such as toolbar & canvas theme, major & minor gridlines that are available in ‘Display Settings’ have been added to the ‘Design’ tab for improved discoverability. 

10. Measure only highlight 

Using the ‘Measure only highlight’ option, you can apply banded rows only to the measures to recreate some of the Excel table layouts. You can also find options for major and minor gridlines and outline in the Display section. 

Measure only highlight

Note: To apply a background color to the row headers, enable ‘Rails’ as highlighted in the ‘Actions’ section, select the columns and use the ‘Fill color’ option.  

11. Redesigned compact launch wizard

The launch wizard has been redesigned to display the properties in a single pane for improved usability. 

12. UX improvements for discoverability

Row and column grippers have been enhanced to improve discoverability of key features along with right-click enabled for column and row selection as well.  

Grippers for calculated measures, data input columns, subtotal rows, and child rows are shown in the below image as a sample. 

UX improvements for discoverability

In addition to these features, we also have several enhancements and bug fixes as part of this release. 

  1. Column-wise semantic formatting (Negative number formatting)  
  1. Custom note indicator option which displays the first letter of the note 
  1. Header footer preset enhancements in Report+ 
  1. Custom separator for combining column headers 
  1. Search option includes results from in-line charts 

Note: Version 1.8 is currently available only in our website as of December 7th and it would take about 2 weeks in the AppSource. 

We have introduced the Premium developer license for Inforiver Matrix which is $95 per developer per month for unlimited viewers. With this license, a named developer will be able to create and share reports with unlimited viewers in the organization (no license assignment for viewers is required). For more details, visit this page

We'd love to hear your ideas for Inforiver – be it a cool new feature or an improvement on existing features. Visit the Inforiver Community to share your ideas, vote on other submissions, and interact with other users. 


Inforiver Logo
IBCS Certified
Power BI certified
About Inforiver!

Inforiver drives business productivity and business performance with faster time to insights inside Power BI through an intuitive no-code experience. The product is developed by Lumel Technologies (formerly Visual BI), which has a decade of experience in building add-on solutions on top of BI platforms (SAP BI and Power BI) with our suite of innovative products such as ValQ, xViz, and BI Hub
Headquarters
5920 Windhaven Pkwy, #130
Plano TX 75093
ValQ
xViz
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram