Forum Discussion
Multiple relationships between tables
I've looked online and messed around but still need assistance. I want to maintain my "Store" relationships but also add relationships for "Week.2". I'm using these for filtering however, the filters...
Thanks. I've resolved my issue by creating 2 filters and combing them as a group and selecting "sync slicers"
lbendlin
Super User
Super UserThe 202201 format for the week is preferable.
Power BI would like to see a data model that has dimension tables (things you can filter by) surrounding fact tables (things you can compute) in a star schema or snowflake schema. Dimension tables have primary keys that are unique, and that are pointing to fields in the fact table in a 1:* relationship. Your data model snapshot seems to be lacking these features. Please consider cleaning your data model up so you can arrive at the star/snowflake schema.
Thanks. I've resolved my issue by creating 2 filters and combing them as a group and selecting "sync slicers"