Forum Discussion
Post PartisanWhy filter does not propogate
Hi mp390988 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Deku rosha_rosha Thank you for your quick response.
When you expand a customer in the matrix visual, Power BI filters the data based on that customer using the relationship between DimCustomer and FactInternetSales. This filter flows into the fact table and restricts the rows to only those related to that customer. From there, Power BI identifies the ProductKeys associated with that customer's transactions. Using those keys, it retrieves the corresponding product names from DimProduct. Even though there’s no direct relationship from DimCustomer to DimProduct, Power BI doesn’t need one — it leverages the fact table to bridge the two. That’s why you only see the products actually purchased by each customer, rather than a full list of all products.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy
Post PartisanThank you for your reply but you completely lost me now.
Hi mp390988 ,
Thank you for reaching out to Microsoft Fabric Community Forum.
Deku rosha_rosha Thank you for your quick response.
When you expand a customer in the matrix visual, Power BI filters the data based on that customer using the relationship between DimCustomer and FactInternetSales. This filter flows into the fact table and restricts the rows to only those related to that customer. From there, Power BI identifies the ProductKeys associated with that customer's transactions. Using those keys, it retrieves the corresponding product names from DimProduct. Even though there’s no direct relationship from DimCustomer to DimProduct, Power BI doesn’t need one — it leverages the fact table to bridge the two. That’s why you only see the products actually purchased by each customer, rather than a full list of all products.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
B Manikanteswara Reddy