Type of Relatioship

[DrayCount]

Hello Community
(Screenshot is attached for the reference)

I would like to create a dashboard in Power BI for my livestock farm. The goal is to have the dashboard enable me to select a specific tag number and date range, and then automatically display all the treatments that have been performed on that particular animal during the selected period. My data is stored in an Excel file, with dates arranged in a row representing the entire year, and tag numbers listed in a column. The treatments are recorded under the respective date and associated with the corresponding tag number of the animal. I would like to know which type of relationship should be used in order to create this dashboard effectively.

[Legend_11]

Try creating 3 tables,

1 - fact

2 - date

3 - tag(dimension)

date and tag --one ----to ---many-----> fact table

use two slicers one for date and one for tag

Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist. 

[DrayCount]

Thankyou So Much. I'll try it and will get back to you in case of any query.

[Idrissshatila]

Hello @DrayCount ,

The best data Mdel to use is the star schema model, so make sure to build your model as start schema.

Check it out here https://learn.microsoft.com/en-us/power-bi/guidance/star-schema

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin