Forum Discussion

UmaShankar's avatar
UmaShankar
Regular Visitor
3 years ago

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 :

  1. Selectedvalue is successful if one category selected, So in case of multiple selection it fails.
  2. 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