The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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
Solved! Go to 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
@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