Slicer from fact table filters values from the dimensions

[Asmaa-elsheikh]

Hi Dears,

I have 1 fact table (users data) & 3 dim tables 

I added a slicer from the fact table to filter the values from the 3 dim tables, but it does not work correctly, what should I do?

[Anonymous · Accepted solution]

Hi @Asmaa-elsheikh 

Here are a few steps to troubleshoot and potentially resolve the issue:

1. Verify Relationships: Check if the relationships between your fact table and the dimension tables are correctly set up. Each dimension table should have a unique key that is related to a corresponding foreign key in the fact table. For more details on setting up relationships, please refer to Model relationships in Power BI Desktop - Power BI | Microsoft Learn.
   
   

2. Review Slicer Configuration: Ensure that the slicer is correctly configured to filter the other visuals or tables. Sometimes, slicers are set to not interact with certain visuals, which can be adjusted in the slicer's Format pane under the Edit interactions option. For more on slicer interactions, see Slicers in Power BI - Power BI | Microsoft Learn.
   
   

3. Cross-filter Direction: In the relationship settings, the cross-filter direction plays a crucial role in how filters propagate through the model. Make sure it's set to 'Both' if you want the slicer to filter from the fact table to the dimension tables. This setting can significantly impact how slicers work with your data model. More information on cross-filter direction can be found here: Create and manage relationships in Power BI Desktop - Power BI | Microsoft Learn.

Best Regards,

Jayleny

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.