Forum Discussion

Kotla's avatar
Kotla
New Member
1 year ago
Solved

Combine multiple Matrix

Hello All, 
I have 3  Matrix visual with same column headers as below.

Now, I need to combine them into a single Matrix visual in below format. 

Note: All of these Row are calculated Metrics. 

 

  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi Kotla ,

    I create three tables and make them become three matrix visuals.

    Then I think you can go to Power Query and choose Append Queries.

    Finally you can let the new table become a matrix.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

2 Replies

  • Add all your measures to the values area. Then change the settings to "show values on rows"

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi Kotla ,

    I create three tables and make them become three matrix visuals.

    Then I think you can go to Power Query and choose Append Queries.

    Finally you can let the new table become a matrix.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.