Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe 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.
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.
Solved! Go to Solution.
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
Proud to be a 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
once done. Use Matrix visualization
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!!
Proud to be a 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
once done. Use Matrix visualization
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!!
Proud to be a 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
Proud to be a Super User! | |
User | Count |
---|---|
132 | |
74 | |
70 | |
58 | |
54 |
User | Count |
---|---|
192 | |
96 | |
67 | |
64 | |
54 |