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 :   Brand FiscalPeriod Measure1 Measure2 A  P1...
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

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