Forum Discussion
Helper VSelected 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
ChiragGarg2512Solution Sage
Try using a specific slicer for brand instead of using filter pane.
BIanonI need to always filter this value away from this page and not expose the option to turn it back on to my users
- ChiragGarg2512
Try drill-through.
- thuoc115
Advocate I
I'm also waiting for the answer.
