Forum Discussion

ksoroush's avatar
ksoroush
New Member
2 years ago

Sorting based on Selection Sequence from Slicer

Hi there, I am trying to provide a user with an empty table alongside a slicer (vertical list) so that they can select items from the slicer in their desired sequence. Specifically, their first ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi ksoroush ,

Your solution is great, vicky_ . It worked like a charm! Here I have another idea in mind, and I would like to share it for reference.

I create a measure on my table and here is the DAX code.

Measure = 
VAR _Selected =
    VALUES ( 'Table'[Column1] )
RETURN
    IF (
        MIN ( 'Table'[Column1] ) IN _Selected,
        SELECTEDVALUE ( 'Table'[Column1] ),
        BLANK ()
    )

Then when I use a slicer and it will get what you want.

 

 

 

Best Regards

Yilong Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Soroush_K's avatar
Soroush_K
New Member
2 years ago

Hi Yilong,

Thanks for your reply. 

Let me clarify this again. The table and slicer you created follow the row number logic. If I select 3 first and then 2, 2 moves up and takes the previous row. However, I want 3 to take the first row (as it is my first selection from the slicer), followed by 2. My data is in text format, though.