Forum Discussion

Sasha's avatar
Sasha
Icon for Helper III rankHelper III
6 years ago

Slicers syncing filters

Hi,

I have a slicer of country which I want to be a slicer and not a filter as it's an important dimension the user will work with and I want it to be visible and trivial.

On the filter pane I've added a "City" filter (I don't want it a slicer)

Is there a way the slicer will filter the filter?

Say, a user chose "UK" in a country slicer and then wants to filter cities - is there a way for the filter to show only UK cities?

Thanks in advance,

Alex

Need Help

1 Reply

  • eisenhower's avatar
    eisenhower
    Frequent Visitor
    6 years ago

    Sasha We tried to achieve this same behavior between our City and State dimension filters and found that we needed to create an SSAS relationship in the Dimension Usage tab of the Cube. Secondly, there needs to be a foreign key relationship between the two dimensions, so the cube knows which Cities related to which State.