Forum Discussion
Filtering visuals using slicers combinations
Hi Bimbone ,
Thank you for reaching out to us on the Microsoft Fabric Community Forum.
Please post regarding the same in the issues forum for wider visibility:
Issues - Microsoft Fabric Community
If this post was helpful, please give us Kudos and consider marking Accept as solution to assist other members in finding it more easily.
Hey there!
Here are a few solutions for you:
1. Ensure Correct Relationships Between Tables
- Verify that the Competizione, Anno (Year), and CittaMain (City) fields are properly related in your data model.
- The main table (CoppeCitte) should be linked to the slicer tables via one-to-many relationships.
- If using a separate slicer table, ensure it’s correctly related to CoppeCitte.
2. Use a Measure to Filter "SFPairs" Dynamically
Create a DAX measure to check if the selected slicer values match the records in the table:
SelectedSFPairs =
VAR SelectedComp = SELECTEDVALUE( CoppeCitte[Competizione] )
VAR SelectedYear = SELECTEDVALUE( CoppeCitte[Anno] )
VAR SelectedCity = SELECTEDVALUE( CoppeCitte[CittaMain] )
RETURN
IF(
SELECTEDVALUE( CoppeCitte[SFPair] ) IN
FILTER(
CoppeCitte,
CoppeCitte[Competizione] = SelectedComp &&
CoppeCitte[Anno] = SelectedYear &&
CoppeCitte[CittaMain] = SelectedCity
), 1, 0
)
Hope this helps!
😁😁
