Forum Discussion
Relationships
I have several tables with "Site ID" and I want to create a slicer where by selecting a specific Site all visuals will interact.
Do I need to create all relationships (many to many)?
Help required! All I need is to select a specific site on the slicer and have everything linked.
Thanks
1 Reply
Hello Anonymous ,
What you should do is that create a dimension table for sites which have every unique site with the ID and the connect it with these two tables and use it to filter both tables.
this is called a starschema model, check it out 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 👍
