Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Relationship & Interaction Issue with tables

Hi,
I am new to power bi and I am seeking for the help.
I have 2 tables A which comes from Big Query & B which comes from clusters.There is no common column between these two tables so I tried to create key using the Week&Region&Channel (this column were available in both table,but due to data issue we can not join them directly).So through the key ,relationship will be many to many between table A & B.(which leads to wrong data.)so I tried to join Table A with table C which is Calender table through Date column & Table C to table B through date column. and now I got correct data.(as that should be the standard practice rather than to go with many to many relationship).

Now,the problem is I need to interact column like channel/region/manufacturer ( this would be my slicers) which is in table B to interact with the column value of table A.(this value is in table visual). I want to interact this values as per selection of slicers but it is not interacting.Please help me to understand what is the problem here or any othe rapproach which gives me correct data and interact table b values with slicers of table A.

Thanks in Advance.

No Replies