Multiple row headers in Matrix visual

[Arunsundar]

Hi Team,

Greetings!

I have a requirement to get multiple row headers in matrix visual in Power BI. Lets say, I have a table as below :

Brand	FiscalPeriod	Measure1	Measure2
A	P1	100	200
B	P2	110	210
C	P3	120	220
D	P4	130	230

I would like to have a report as below.

As_RequiredAsofnow_acheived_PowerBI

But in the matrix visual, if I add two metrics, for a single fiscal period, the metrics are split. whereas under single metric, the time periods have to be split. Similarly I have more measures in this case. Kindly suggest if you have any ideas to this challenge.

Thanks in advance,

Arunsundar M

[v-yuezhe-msft · Accepted solution]

@Arunsundar,

If Measure1 and Measure2 are two columns in your table, you can first unpivot columns in the table, then create Matrix visual.


Regards,
Lydia

[elia22gr]

Hi @v-yuezhe-msft ,

If my measures are not columns how could I get the desired matrix?

Thank you in advance,

Eleftheria

[Arunsundar]

Hi Lydia,

It worked. Thats cool.

Thanks,

Arunsundar M