Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Arunsundar
Frequent Visitor

Multiple row headers in Matrix visual

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 :

 

BrandFiscalPeriodMeasure1Measure2
A P1100200
B P2110210
CP3120220
DP4130230

 

I would like to have a report as below.

 

As_RequiredAs_RequiredAsofnow_acheived_PowerBIAsofnow_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

 

 

1 ACCEPTED SOLUTION
v-yuezhe-msft
Employee
Employee

@Arunsundar,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

3 REPLIES 3
v-yuezhe-msft
Employee
Employee

@Arunsundar,

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

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi @v-yuezhe-msft ,

 

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

 

Thank you in advance,

Eleftheria

Hi Lydia,

 

It worked. Thats cool.

 

Thanks,

Arunsundar M

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.