Relationship

[Atchaya-Prabhu]

 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 

@amitchandak 

[Anonymous · Accepted 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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[foodd]

How to Get Your Question Answered Quickly      

[Ashish_Mathur]

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.

[Idrissshatila]

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 👍

Follow me on Linkedin