Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
MP_123
Microsoft Employee
Microsoft Employee

relationship between table

hi, i have 2 tables as below:

 

date              window dim dim dim

1-1-2016          1         X       y     z

2-1-2016          28         X       y     z

 

 

date              window dim dim 

1-1-2016          1         X       y     

2-1-2016          7        X       y    

 

the schema of the two tables are similar but not the same

i have another mapping table (one to mant with the two tables above)

window      title

1                daily

7                weekly

28              monthly

 

and i have another table of the time dimension (one to many with the two tables above)

 

i want to have two slicers: date and 'title'

the problem is that: i want that if i select 'daily', dates will be filtered with only daily date (from the two tables)

and if i filter date, it should affect both tables

 

how can i do it?? i wanted to create combined table with date and window, but power bi doesn't support manyt to many relationship

thanks!

3 REPLIES 3
CheenuSing
Community Champion
Community Champion

Hi @MP_123

 

Could you please share some data and the output you expect.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

hi@CheenuSing

attached my releationshipCapture12.PNG

 

i want to create two slicers: time and date (yellow) and i want it to affect each other:

for example if i select time = 'Weekly' so the dates from Time table will filter (and the other tables also) and if I select date, also all tables will be filter

bottom line: i want to have relationship between all tables

the problem is that if i'm combining all dates from the two fact tables, it's many to many relationship

 

thanks!

Hi @MP_123

 

Please post some data of each table or put it in one drive and share the link.

 

Cheers

 

CheenuSing

Did I answer your question? Mark my post as a solution and also give KUDOS !

Proud to be a Datanaut!

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors