Forum Discussion
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
hiAnonymous
attached my releationship
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
