Forum Discussion
Petja
Advocate II
Advocate IIHow to filter a slicer dynamically based on selection on field parameter
Hi, I have a report where there are multiple different measures. The user can choose from field parameter slicer which measures they want to see. I also have a slicer for department, which uses a...
Add below Measure (Show Department) and apply this as a visual filter to Department Slicer (DepName) -> Show Department = "1"
Show Department = VAR _SelectedMeasure = SELECTEDVALUE ( 'Parameter'[Parameter Fields] ) RETURN SWITCH ( TRUE(), _SelectedMeasure = NAMEOF([Calc1]), IF ( NOT ISBLANK ( [Calc1] ), 1 ), _SelectedMeasure = NAMEOF([Calc2]), IF ( NOT ISBLANK ( [Calc2] ), 1 ), 1 )Result -
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
PetjaAdvocate II
Advocate IIHey, here is a sample file, so I want the 'Parameter' slicer to filter the 'DepName' slicer.
Cannot attach files so heres a link:
Rupa01
Solution Sage
Solution SageAdd below Measure (Show Department) and apply this as a visual filter to Department Slicer (DepName) -> Show Department = "1"
Show Department =
VAR _SelectedMeasure =
SELECTEDVALUE ( 'Parameter'[Parameter Fields] )
RETURN
SWITCH (
TRUE(),
_SelectedMeasure = NAMEOF([Calc1]),
IF ( NOT ISBLANK ( [Calc1] ), 1 ),
_SelectedMeasure = NAMEOF([Calc2]),
IF ( NOT ISBLANK ( [Calc2] ), 1 ),
1
)Result -
💡 Helpful? Give a Kudos 👍 — keep the community growing
✅ Solved your issue? Mark as Solution ✔️ — help others find it faster
Best regards,
Rupasree Achari | BI & Fabric Analytics Engineer
- Petja
works beautifully, thank you!