change layout in matrix

[Anonymous]

Hi!

The typical layout of data in a Matrix exhibit in Power BI is like this:

	2015		2016		2017		2018		Total
Attribute	Measure1	Measure2	Measure1	Measure2	Measure1	Measure2	Measure1	Measure2	Measure1	Measure2
A	89	70	44	100	32	76	16	98	181	344
B	37	57	77	98	46	84	46	28	206	267
C	23	19	91	40	72	18	62	84	248	161
Total	149	146	212	238	150	178	124	210	635	772

I would like it to be more like a possible format that is attainable with an Excel pivot table, like this:

	2015	2016	2017	2018	Total	2015	2016	2017	2018	Total
Attribute	Measure1	Measure1	Measure1	Measure1	Measure1	Measure2	Measure2	Measure2	Measure2	Measure2
A	89	44	32	16	181	70	100	76	98	344
B	37	77	46	46	206	57	98	84	28	267
C	23	91	72	62	248	19	40	18	84	161
Total	149	212	150	124	635	146	238	178	210	772

This allows you to scan along the rows for each measure to see if there is any trend with time, whereas the mixing of measure across a row in the typical matrix layout makes this more difficult.

Does anyone know if this is possible with a Power BI Matrix or other visualisation?

Many thanks for any help.

Mark

[Anonymous]

HI @Anonymous,

Nope, this is impossible. If column label is based on two columns, you can modify sort order in column field to change grouping order. (measures can't achieve this)

Regards,

Xiaoxin Sheng