Forum Discussion
fabconmvp
1 year agoHelper I
Slicer 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
1 year agoSuper User
You 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