Rank by Slicer Selection Order and Sort by Rank

[SamiCBC]

Hi,

I have a table called Task with a column called TaskName, which has the values TaskA, TaskB, and TaskC.

I have created a slicer using TaskName and enabled multiple selection. I want to create a DAX measure called TaskOrder that behaves according to the following example:

If I select TaskB first, the result should be:
TaskA,
TaskB,1
TaskC,

If I then select TaskC after selecting TaskB, the result should be:
TaskA,

TaskB,1

TaskC,2

Finally, if I select TaskA, the result should be:

TaskA,3

TaskB,1

TaskC,2

After that, I want to use a table visual to display the TaskName values sorted by TaskOrder, which reflects the order of selection.
Thank you,
Sami.
sami.mawass@outlook.com

[Anonymous]

Hi @SamiCBC ,

Does that make sense? If so, kindly mark my answer as the solution to close the case please. Thanks in advance.

Best Regards
Community Support Team _ Rongtie

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

[Anonymous]

Hi @SamiCBC ,

I have understood your meaning. However, now Power BI does not support. As far as I know, there is no way for Slicer to judge the order of selection, and even you can use more than one measure or Slicer, which has no way to judge.

Best Regards
Community Support Team _ Rongtie

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

[Anonymous]

Hi @SamiCBC ,

Unfortunately, this is by design. Power BI is now unable to achieve what you need . You can submit an idea for it at   https://ideas.powerbi.com/ideas/   and wait for users with the same needs as you to vote for you to help make it happen as soon as possible.

If it does not help, please provide more details .

Best Regards
Community Support Team _ Rongtie

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

[SamiCBC]

Hi @ v-rongtiep-msft,

Thank you for your reply, is there another workaround solution for what I asked for?
or can we have multiple measures:  
SelectedValue1
SelectedValue2
SelectedValue3

Thank you,
Sami.
sami.mawass@outlook.com