Relationships

[Anonymous]

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

[Idrissshatila]

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 👍

Follow me on Linkedin