Forum Discussion
Relationship
how to connect relationship one to many between two tables I used many to many using banner name but slicer not working
I want to connect one to many between these tables
kindky let me know the possible solution
Hi Atchaya-Prabhu ,
I suggest you to create Dim tables like a DimBannerName table to create a relationship between it and Table1 / Table 2.
DimBannerName and Table 1 (one to many)
DimBannerName and Table 2 (one to many)
You may refer to below offical blog to learn more details about many to many relationship in Power BI.
For reference:
Many-to-many relationship guidance - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
4 Replies
Hello Atchaya-Prabhu ,
You should build this model as a start shcema model in order to build one to many relationship.
learn more on how to build a star shcema model using this link 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 👍
Hi,
What exact result are you expecting? Share data in a format that can be pasted in an MS Excel file and show the expected result.
Hi Atchaya-Prabhu ,
I suggest you to create Dim tables like a DimBannerName table to create a relationship between it and Table1 / Table 2.
DimBannerName and Table 1 (one to many)
DimBannerName and Table 2 (one to many)
You may refer to below offical blog to learn more details about many to many relationship in Power BI.
For reference:
Many-to-many relationship guidance - Power BI | Microsoft Learn
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
