Forum Discussion

Camstr's avatar
Camstr
Helper I
2 years ago
Solved

Slicer and Filter behaviour

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

 

Need Help
Show and Tell
Tips and Tricks
  • amitchandak's avatar
    amitchandak
    2 years ago

    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

2 Replies