Change order of 2 value fields in matrix

[CSSR]

Hi,
I am unable to change sorting of value fields in below metrix, well I do not know how to do it. Currently, I have
 - two measures (ABC, 123) in a value field,
 - calendar hierarchy in a column field and (months and Years)
 - customer column in row field. 

As you can see from a below print screen (the 1st one), my value fields are grouped by period, so I have ABC and 123 under Period 01 etc. and this is not what I want. I want to see a trended view 1 - 12 months for ABC measure with subtotal after it and then the same trended view for 123 measure (see 2nd print screen).
I have been playing with it for since yesterday and I could not find a way how to do it 😞 ....

This is how it looks like now (not desired outcome)

This is how I want to have it in power bi matrix (desired outcome)

these are my fields in matrix

Thanks in advance for your help and comments! 

[MFelix · Accepted solution]

Hi @CSSR ,

Create a disconected table with the following information

ID	Measure
1	123
2	ABC

Make the sorting of the Measure column by the ID column then do the following steps:

• Add Measure column on the matrix before the Year hierarchy
• Create the following measure:

Values for matrix = SWITCH (SELECTEVALUE(Table[ID]), 1 , [123], 2, [ABC])

Now use this measure instead of the other two in the values.

[Pragati11]

Hi @CSSR ,

Try making your both measures for ABC and 123 as columns. Then move these both columns to the COLUMN section in the matrix visual.

Try this if this works.

Thanks,

Pragati