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

Table and Matrix Layouts in Power BI

by Inforiver | Oct 03, 2023 |

Summary: Inforiver offers the flexibility to deliver tabular reports in multiple layouts in Power BI, including the Pivot Table layout in Excel that many users are familiar with.  

We often prefer tabular reports over charts in Power BI when 

(a) we have a need to display multiple records, or 

(b) when we have a larger number of dimensions & measures that need to be displayed at once. 

Inforiver supports the following 5 types of tabular report layouts in Power BI. 

  1. Hierarchy
  1. Outline 
  1. Table 
  1. Stepped 
  1. Drilldown 

All the above are accessible from the Home -> Layout menu item.

Layout menu

Let’s take a quick look at each of them. 

1. Hierarchy 

By default, Inforiver delivers data in a hierarchical, expand/collapse-enabled format. Note that ragged hierarchy support is provided out-of-the-box without the need to write any code


2. Outline 

The Outline layout is similar to the Hierarchy layout except that each dimension is captured in a separate column. 


By default, the Excel-like 'ruler' is enabled for this layout (seen above the first row & before the first column). The ruler is used to easily resize or select specific rows and columns as you do in spreadsheets. You can hide this ruler by de-selecting the ruler icon on the toolbar. 

3. Table 

The table option shows categories in a tabular format, without any expand-collapse hierarchies for rows.  

This layout allows us to sort based on any dimension first (e.g.,) Category – something that is not possible in Hierarchy or Outline layouts. 


4. Stepped 

The Stepped layout is similar to the Outline layout but with the addition of an additional Total row for each category member.


5. Drilldown 

The drill down layout lets you explore one branch at a time in the hierarchy. This is also an ideal option when you have a huge volume of rows. 


Inforiver also allows you to customize all the above layouts when you have multiple measures. These options are available at the bottom of the Layout menu. We will explore this in one of our upcoming posts. 



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