Adding Measures to Rows in a Matrix

[garynorcrossmmc]

Hi all,

I am trying to add measures to the Rows section of a matrix and this isn't working.  Here is the view I'm trying to get to:

The three values for 'Category' are already created as measures.  I have Year/Month on a date table, and I'd like to show the measures and Year on Rows, with the months shown on the columns.  Is this possible?

And yes, I've already tried Show on Rows and it does not fit this requirement:

Thanks!

[V-lianl-msft]

As far as I know, the built-in method is only "Show on Rows ". I'm afraid there are no other methods to meet your needs.

[amitchandak · Accepted solution]

@garynorcrossmmc , Measure before dimension is only possible when you convert measure to rows too.

Means unpivot the data

column header grouping
https://www.daxpatterns.com/dynamic-segmentation/
https://community.powerbi.com/t5/Desktop/Matrix-Display-Values-above-Columns/td-p/256905