Slicer and Filter behaviour

[Camstr]

Hello,

I have created a simplified example that communicates by confusion over slicer vs. filter behaviour.

Your help would be appreciated.

In the example below I have "Country" = "UK" & "City" = "London" as page level filters.  The table reflects the desired filtering.

However, I want the user to be able to filter by "Storename" using a slicer.

Why does my slicer not reflect the filters on page?

Ideally it should show only the Storenames in "London", right? 

If you imagine a larger data model with several hundred stores per City, then that gets frustrating for the user...

If I try to place filters directly on the Slicer visual that doesn't seem to work..

Slicer vs. filter

My model is a simplified Star schema, relationship "Many" is on the fact table side, "one" is on the dimension tables that contain unique records.

Model

[Camstr]

Thanks @amitchandak !!

[amitchandak · Accepted solution]

@Camstr , You have to make joins bidirectional

or create a measure

countrows(Filter(Store, Store[CityID] in Values(Location[City]) )

Use this measure in the visual level filter of the store

How to filter the slicer of a disconnected table: https://youtu.be/cV5WfaQt6C8