Forum Discussion
Solved
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 ...
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.
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.