How to change layout of matrix

[Yamada1]

Hi All, I would like to change the layout of matrix.

I use measure for sum of sales and CGS.

Current layout

Desired Layout

Do you have any good idea?

Thanks in advance.

[Yamada1 · Accepted solution]

Thank you for quick advise.

If the data is like the below,  is it possible to change this layout?

I could not attached the xcel file or Power BI file so I attahced just the screen shot.

[mussaenda · Accepted solution]

Hi @Yamada1 ,

This is the current layout from the pbix I attached

[mussaenda]

Hi @Yamada1 ,

[Yamada1 · Accepted solution]

Thank you for quick advise.

If the data is like the below,  is it possible to change this layout?

I could not attached the xcel file or Power BI file so I attahced just the screen shot.

[Anonymous · Accepted solution]

Hi @Yamada1,

You can do unpivot columns on the Sales and CGS fields to convert them to attribute and value.

Unpivot columns - Power Query | Microsoft Learn

Then you can put the attribute field on matrix column and above the Quarter field and use value field on matrix value field to achieve your requirement.

Regards,

Xiaoxin Sheng

[mussaenda · Accepted solution]

Hi @Yamada1 ,

This is the current layout from the pbix I attached

[Yamada1]

Thank you mussaenda.

I undersood, your idea.

If sales amount cloumn and CGS amount clumn is separete, is it possible to make same layout which you suggest?

Thanks.