How to maintain the sequence of slicer selections in Power BI?

[novel]

Hello Community,
I need help with sequencing slicer selections in Power BI. My goal is to capture the order in which options are selected from a slicer and display them with corresponding numbers to indicate the selection sequence.

For example, if the slicer contains the following options: ABC, CDE, EFG, HIG, etc.

And the user selects the options in this order: EFG, ABC, HIG, then the result should display:

1. EFG
2. ABC
3. HIG

I’ve tried using DAX with SELECTEDVALUE and CONCATENATEX, which gives me the selected values, but it automatically rearranges the output in ascending or descending order.

How can I achieve the desired sequence of selections and display it as shown above?

Any guidance or suggestions would be greatly appreciated!

[danextian]

Hi @novel 

I don't think that capturing the order in which visual elements or slicer items are selected is possible. There's no function that does this. DAX is not designed for this type of tasks. CONCATENATEX will concatenate values in alphabetical order by default or based on a custom sort column, but this custom sort column is pre-determined or based on a column virtually calculated.