Forum Discussion
UmaShankar
3 years agoRegular Visitor
First Selected value from Slicer if selected multiple values
Hi Friends,
Need your help to get the first selected value from slicers if we have selected multiple values in the slicer.
I need this for Dynamic Title: Sometimes user needs to select multiple Categories on the slicer by pressing Ctrl Key. But I need the first selected Category for the Title.
What I have tried :
- Selectedvalue is successful if one category selected, So in case of multiple selection it fails.
- Concatenatex to combine the all selected categories, then took the first category by using Left and search function, but concatenatex is combining the categories on the basis of ASC/DESC order which we provide or by default like ASC order.
But the requirement is as we select the first category even from mid of the list then what ever we select second Category, it should be combined in the sequence as it was selected, then I will use the Left function to extract the first selected category.
Thanks
No RepliesBe the first to reply