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

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
abhargava
Frequent Visitor

Merge/Combine Matrix table that contains diferent measres.

I have three matrix tables below: 

abhargava_0-1729580658715.png

 

I want to cmbinethe matix table into one like below: 

abhargava_1-1729580692637.png

Is it possible in Power BI to do this? 

2 ACCEPTED SOLUTIONS
abhargava
Frequent Visitor

@ryan_mayu  The value (measures) come from the same table. 

View solution in original post

Then I don't think we need to create dim table. you just add all measures to one matrix table. If this does not work, pls proivde some sample data and expected output.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

4 REPLIES 4
v-zhengdxu-msft
Community Support
Community Support

Hi @abhargava 

 

Could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered to close this topic?

 

Best Regards

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

abhargava
Frequent Visitor

@ryan_mayu  The value (measures) come from the same table. 

Then I don't think we need to create dim table. you just add all measures to one matrix table. If this does not work, pls proivde some sample data and expected output.





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




ryan_mayu
Super User
Super User

@abhargava 

 

The value comes from one table or different tables. 

 

if they come from different tables, I  think you can create a dim project table and create relationship between dim table and those tables. 

 

Then you can only create one matrix visual to display all the data





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

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