Forum Discussion
fabconmvp
Helper I
Helper ISlicer priority
Hello everyone, I hope you are doing well. I have a slicers below in a image and I want that whenever I selected the slicer that will be give the value name based on sequence slicers. Fo...
Deku
Super User
Super UserYou can use concatenatex to return a sequence of values as a scalar string.
Concatenatex( values( slicer[region] ), slicer[region], "-", slicer[Region], asc)
This will order the resulted based on a expression in the case above region alphabetically ascending, but can be customized.
There is no way for this to know what order you selected the values in the slicer though, which is sounds like you what you wanted to achieve