Forum Discussion
Solved
Managing relationships between datasets with date variable
Hello, I am a new user of Power BI and am currently working on establishing relationships between several datasets that include variables: Feeding data for different groups of farm animals...
clean up your data and create a data model
Adding injuries to that chart will create cognitive overload. Use separate visuals.
Read about how to handle SCD2 - Slowly Changing Dimension Type 2
You will want to combine "like" tables (including a source identifier column), otherwise your data model will quickly become unmanageable.
Think about the nature of your data and try to separate it into facts (something you can summarize) and dimensions (something you can filter by).