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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
BIanon
Helper V
Helper V

Selected slicer measure

Hello community,

I have a 'selected slicer' measure which displays all selected slicer values for my users. It's a long nested if statement, but generally works.
A snippet of my DAX code:
& IF(
ISFILTERED( 'Product'[Brand] ),
" | Brand: " & CONCATENATEX( ALLSELECTED( 'Product'[Brand] ), 'Product'[Brand], ", " )
)

My problem is, if I apply a page wide filter where I filter away one specific brand, the slicers doesn't work. How can I adapt my DAX to this scenario?

The perfect solution for me, would be if de-selecting a brand just has no effect but I am not sure how to achieve this

4 REPLIES 4
thuoc115
Advocate I
Advocate I

I'm also waiting for the answer.

ChiragGarg2512
Solution Sage
Solution Sage

Try using a specific slicer for brand instead of using filter pane.

I need to always filter this value away from this page and not expose the option to turn it back on to my users

Try drill-through.

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

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

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors