Previous User Selected Value

giammariam — Wed, 11 Oct 2023 00:20:58 GMT

I don't think this is possible, but I thought I'd ask here in case I'm missing something. Imagine a scenario with a table that has a single column called Item. In this column are the values A-E. Item is used in a slicer. I would like two measures: [Selected Item] and [Previously Selected Item]. The DAX for [Selected Item] is simple. In this example, if the user were to select the slicer option "D" and then subsequently change the selection in the slicer to option "B", is it possible to set up [Previously Selected Item] to return "D"? As far as I know, there is no history of the filter context, but I wouldn't be surprised if there was some some set of functions out there that would allow for this.

See the below screenshot for the desired result in the scenario described above:

Re: Previous User Selected Value

ValtteriN — Wed, 11 Oct 2023 06:17:43 GMT

Hi,

As you suspected it is not possible for Power BI to "remember" the filter states user selects. This information isn't stored anywhere and is lost when the filter state changes.

I hope this post helps to solve your issue and if it does consider accepting it as a solution and giving the post a thumbs up!

My LinkedIn: https://www.linkedin.com/in/n%C3%A4ttiahov-00001/

topic Previous User Selected Value in DAX Commands and Tips

Previous User Selected Value

Re: Previous User Selected Value