Using one dim table to filter other dim tables and a fact table

[Espenblo]

I have multiple dim tables and a fact table. I want to filter all other dim tables and the fact table from one dim table. For example, I have a DimCountry, DimCustomer, DimProduct and FactSales. I have slicers for Country, CustomerType and ProductName. I want to filter out the CustomerTypes, ProductNames, and the fact table when I change the slicer in DimCountry.

[Adamboer]

To achieve this in Power BI, you can create a bi-directional relationship between DimCountry and other dim tables and the fact table. To create a bi-directional relationship, you can follow these steps: Go to the Relationship view in Power BI Desktop. Select the relationship between DimCountry and other dim tables and the fact table. Click on the Manage Relationships button. Check the checkbox for "Enable bi-directional cross-filtering" in the Manage Relationships dialog box. Click OK to save the changes. After creating a bi-directional relationship, you can use the slicer for DimCountry to filter all other dim tables and the fact table. This will allow you to filter out the CustomerTypes, ProductNames, and the fact table when you change the slicer in DimCountry.

[ThxAlot]

You may refer to "Snowflake" model for further technical details.