Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Camstr
Helper I
Helper I

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. filterSlicer 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.

 

ModelModel

 

1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

View solution in original post

2 REPLIES 2
Camstr
Helper I
Helper I

Thanks @amitchandak !!

amitchandak
Super User
Super User

@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

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors