Skip to main content
Microsoft Idea

Power BI

New

Allow unbalanced nested combinations of measures and columns in Matrix

Vote (2) Share
Michael Shparber's profile image

Michael Shparber on 03 Jun 2022 07:22:56

As of today, if I use several measures in a matrix and also use a field as a column, the matrix will show all the measures for all the values of the field.

We would like much more flexibility.

To allow nesting of columns and measures, but to specify what measure should be "splitted" by columns, and what measures shouldn't.

This will allow much more flexibility in matrix.

For example:

https://1drv.ms/u/s!AoP_9ampPIT7gbwH1sNuSJ2-xI53hA?e=DUrdXl

Here you can see that only Sales measure is "split" by "Year-Month" column, while all other measures are not.


Comments (1)
Michael Shparber's profile image Profile Picture

Michael Shparber on 03 Jun 2022 07:25:23

RE: Allow unbalanced nested combinations of measures and columns in Matrix

And I know I can do workarounds, like build a separate measure for each of the last 3 months, etc...But I don't want workarounds, I want to see this feature as built in.Also, dynamic column/measures names....