Forum Discussion
Data Modeling
Hi VK-Vishnu ,
If you have already implemented a star schema and the common slicers are still not filtering all visuals correctly, then the issue may be related to the relationship configuration rather than the schema design itself. In a star schema, shared dimension tables should filter all connected fact tables through active one-to-many relationships.
Could you please share a screenshot or diagram of your current data model, including the relationships between the 3 fact tables and 4 dimension tables? Also, please confirm whether the slicers are built from dimension tables and whether all relationships are active.
This will help identify whether the issue is related to relationship paths, filter propagation, or model design.
Community SupportHi VK-Vishnu ,
Thanks for reaching out to Fabric Community Forum.
As per Microsoft Power BI guidance, the recommended approach is to model your data using a star schema, where fact tables store measurements or events, and dimension tables store descriptive attributes used for filtering and grouping. In a star schema, fact tables contain key columns that relate to dimension tables, allowing dimensions to filter and summarize the data stored in facts.
You should connect your fact tables to the relevant dimension tables using one-to-many relationships (dimension - fact). This design provides a structured and intuitive model for reporting and analysis and aligns with Microsoft's recommended approach for Power BI semantic models.
Reference:
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
Thank you.
- v-sshirivolu
Hi VK-Vishnu ,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We’re always here to support you