POWER BI Matrix from multiple tables

Hello Anonymous ,

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

Hello Anonymous 

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!!