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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Ohboy_991
Frequent Visitor

POWER BI Matrix from multiple tables

Hello,

 

I am creating a matrix, i have 5 tables to connect and create a matrix out of it.

the common column between these tables is the Product Column.

 

I want to show the Product names on ROWS and all other other KPIs such sales amount , misc expenses, new customer that in the 5 different tables in COLUMNS.

 

additional i need a dropdown that will slice the matrix based on City wise. 

 

how to achieve this ? thanks for the help. 

 

 

2 ACCEPTED SOLUTIONS
Idrissshatila
Super User
Super User

Hello @Ohboy_991 ,

 

so what you need to do is that you need to have a product table that has the unique products and link this table into the other tables that have the data.

 

this is a star schema data model, check it out https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




View solution in original post

sayaliredij
Super User
Super User

Hello @Ohboy_991 

 

You can create Product Table using UNION DAX (combine all product Id or name from all the table)

Connect the product table using following connections

sayaliredij_0-1704912239108.png

once done. Use Matrix visualization 

sayaliredij_1-1704912293649.png

 

Put Product in Rows and KPIs in value section.

 

I can not comment about City as I am not aware how its related to your current data model

 

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

 





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

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Ohboy_991
Frequent Visitor

Thank you @sayaliredij  @Idrissshatila.. !! 

sayaliredij
Super User
Super User

Hello @Ohboy_991 

 

You can create Product Table using UNION DAX (combine all product Id or name from all the table)

Connect the product table using following connections

sayaliredij_0-1704912239108.png

once done. Use Matrix visualization 

sayaliredij_1-1704912293649.png

 

Put Product in Rows and KPIs in value section.

 

I can not comment about City as I am not aware how its related to your current data model

 

Thanks and Regards,

Sayali

Please mark the question solved when done and consider giving a thumbs up if posts are helpful!! 

 





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

Proud to be a Super User!




Idrissshatila
Super User
Super User

Hello @Ohboy_991 ,

 

so what you need to do is that you need to have a product table that has the unique products and link this table into the other tables that have the data.

 

this is a star schema data model, check it out https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

 



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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