Measures in Rows vs. Columns vs. Nested Columns  

In an earlier post, we learned how you can leverage multiple tabular report layouts in Power BI in a single click using Inforiver. In each of these layouts, you can also customize how you want your measures to be displayed (let’s call them ‘Measure Layouts’).  

Measure layouts give you the flexibility to determine how measures are displayed.

Inforiver delivers three (3) ways in which you can deliver measure layouts in a single click. All of these are accessible from the Layout --> Measures menu. 

1. The Default Layout 

By default, all measures are displayed in columns beneath any categories assigned to columns. For example, within Q1, we have 2022 Plan and 2022 Actuals.

2. The Default Layout 

This option moves the measures from the columns and displays them in the rows. Note that 2022 Plan and 2022 Actuals are listed (and repeated) under each product category in rows.

To re-order the measures in this layout, you can click on row gripper and drag the rows to be re-ordered. You can also achieve this via the ‘Manage rows’ popup screen, where you can drag and drop the gripper to reorder measures. 

3. In Columns 

This option puts the measures (2022 Plan and 2022 Actual) in the columns, but with one difference. The measures here are above the column hierarchy categories. 

In this case, you will have 2022 Plan and 2022 Actuals listed on the top of the columns, which can be expanded to reveal the four quarters below. This is very helpful when you are focusing only on one measure at a time. 

For additional information on Nested Measures, click here.