Forum Discussion

Arunsundar's avatar
Arunsundar
Frequent Visitor
8 years ago
Solved

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_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

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    8 years ago

    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

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    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

    • Arunsundar's avatar
      Arunsundar
      Frequent Visitor
      8 years ago

      Hi Lydia,

       

      It worked. Thats cool.

       

      Thanks,

      Arunsundar M

    • elia22gr's avatar
      elia22gr
      Helper III
      3 years ago

      Hi Anonymous ,

       

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

       

      Thank you in advance,

      Eleftheria