Syncing slicers in hierarchy from different data sets

[sd_09]

Hi, 

I am facing issues in syncing slicers from 2 different data sets (the hierarchy for e.g. is: region, country, city). I have tried different approaches like group named the slicers - it works individually (1 field at a time) but not if I enter multiple fields or if I create a hierarchy of these fields.

Does someone know how I could resolve this issue?

Thanks!

[PabloVallejo12]

I deal with it using measure with different VAR, which define the relationship through selectedvalue

[Kaviraj11 · Accepted solution]

Hi,

Can you create one common/lookup table that has all the fields? Make sure to maintain a relationship with facts or other tables and utilize that in the slicer.