Working with data from multiple tables

[taher]

Hi All,

I have an issue with a Database with multiple tables, that are connected with one-to-many relationship for each.

But when I want to use a slicer to filter data I could filter only one way, from the Table, that has the 1 value to that who has multiple values, but not in the reversed direction.

Thanks for help!

Regards,

[v-shex-msft · Accepted solution]

Hi @taher,

>>But when I want to use a slicer to filter data I could filter only one way, from the Table, that has the 1 value to that who has multiple values, but not in the reversed direction.

I want to recommend you to modify the 'cross filter direction' option to 'both'.

Regards,

Xiaoxin Sheng

[taher]

Hi @v-shex-msft,

thanks a lot, it did work.

Best,

Taher

[taher]

I want to get the comment column which is filtered by StorId from Stores Table, the StorId is filtered by ParentTagId. 

so what I would say is that I need this : select comment from Answers-Table where ParentTagId in Tags-Table is xxx.

I would be happy if someone could help.

Regards