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.
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.
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.
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.
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.