Measure Placement - Profitbase/PowerBI-visuals-FinancialReportingMatrix GitHub Wiki

Select where you want to place your measures

(Available from v7.1)

Default:

• Default view is below column headers, where each measure repeats itself under each new column header name:

---

Above Columns:

• New view available is Above Columns, where each column header is repeated under each measure:

Add column formula in "Measures above columns"

available from v8.1.x

With the layout "Measures above columns", you are now able to use the function "Add column formula":

The formula you create in the field will be shown in all columns below the measure.

---

In rows:

(Available from v7.2)

• New view available where measures are listed in the rows:

Measure placement setting is found in the Values section of the Format pane:

Important to note!

Only one measure:

If you only add one measure, the view will look the same, both for Default and Above Columns because the measure name is not visible then:

Each Measure Placement has it's own set of Applied Steps:

If you apply steps in one Measure Placement, e.g. add custom rows, or apply conditional formatting. Those steps will only be applied in the Measure Placement they are made in.

If you later decide to change Measure Placement, from Default to Above Columns, then those steps will no longer be active:

In Default Measure Placement, I have added a custom column, as you can see in the applied steps. The column itself i highlighted in Yellow:

By changing Measure Placement to _Above Columns _ the column, and other applied steps, disappears:

By changing back to Default, it reappears:

This is made by design, so please chose your layout before you start adding steps. If not, you might have to do it twice.