Matrix - Group Column by Measure

[joshua1990]

Hi experts!

I have a simple matrix visual with articles on Row, Week Number as Column and Sales and Revenue per as Values.

Currently the columsn are grouped this way:

22		21		20
Sales	Revenue	Sales	Revenue	Sales	Revenue

But I would like to get this grouping:

22	21	20	22	21	20
Sales	Sales	Sales	Revenue	Revenue	Revenue

How is this possible ?

[v-yanjiang-msft]

Hi @joshua1990 ,

I'm afraid you can't do that, in a matrix it's by design.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[CarlosAugusto]

Buenas tardes, amigo tienes algun ejemplo de como esta estructurada la matriz? si es un objeto visual o es una tabla dentro del BI.

De esta forma poder ayudarte mejor.

Saludos!