Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
DrayCount
New Member

Type of Relatioship

Screenshot 2023-07-13 143047.pngHello 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.

 

 

 

3 REPLIES 3
Legend_11
Resolver I
Resolver I

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. 

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

 

Idrissshatila
Super User
Super User

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos
Follow me on LinkedIn linkedIn
Vote for my Community Mobile App Idea

Proud to be a Super User!




Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.