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

Nesting Measures in Inforiver

by Matt Allington (Self Service BI Expert + Microsoft MVP) , Excelerator BI | Dec 02, 2022 |

This blog is reproduced from here.

The Power BI Matrix visual is similar to an Excel Pivot table, however there are quite a few limitations in the Matrix. In the Power BI Matrix below I have put the product categories on Rows, Calendar Year on Columns and the measure [Total Sales] on Values. At this point, it looks pretty much the same as an Excel Pivot table. It is possible to add more measures to the same matrix, ie [Total Sales PY] as shown below. The default behavior for a Power BI Matrix is that the column (Year in this case) is on top followed by the 2 measures nested below.

Power BI Matrix

For contrast, let me show the same scenario with an Excel Pivot table. There is an option to drag the Values to Rows so the measures are stacked beneath the rows as an alternate presentation if desired.  This actually can be done in the standard Power BI matrix, too.

Excel pivot table drag

However, in a Pivot Table there is also a third option to drag the Values above the Year in Columns in effect nesting the years below the measures instead of the measures below the years.

Excel pivot table nesting

This third alternative is not possible in the standard Power BI matrix

Inforiver Custom Matrix to the Rescue

I have been fortunate to work with Lumel, the company that has developed the Inforiver custom visual. In that capacity, I get to see what they are building and sometimes even influence the features. The Inforiver custom matrix visual has many more features to visualise data than the standard matrix visual including the ability to nest measures this way.

Below is the standard display – the same as the standard matrix.

Standard matrix visual

The same two alternatives provided in Excel are available in Inforiver. Go to Layout\Measures\ and select either “in Rows” or “in Columns”.

Layout - Measures

In rows looks like this.

Layout - Measures - In Rows

And in columns looks like this.

Layout - Measures - In Columns

With Inforiver custom visual it is also possible to hide some of the columns in the display. Just right click the columns you don’t want to see, select “column display”, then “hide column”.

Hide column option

More information available at


Nesting Measures in Inforiver

Share this on:

Get Inforiver brochure

Maximize your business potential with Inforiver's paginated reporting, data entry, planning & budgeting capabilities
Download now
Inforiver Logo
IBCS Certified
Power BI certified

About Inforiver!

Inforiver is the fastest way to do everything in Power BI. It enables citizen developer productivity and unleashes true self-service with our intuitive and interactive no-code data app suite for Microsoft Power BI. The product is developed by Lumel Technologies Inc, who are #1 Power BI Visuals AppSource Partner serving over 2,000+ customers worldwide with their xViz, Inforiver, and ValQ offerings.

5920 Windhaven Pkwy, #130
Plano TX 75093
BI Hub
linkedin facebook pinterest youtube rss twitter instagram facebook-blank rss-blank linkedin-blank pinterest youtube twitter instagram