How to retain data values when the slicer selection changes

[Anonymous]

Hi,

I have  a scatter plot with date on x-axis and some measure value along y-axis. I have  a table placed next to the scatter plot. Whatever data point I am selecting in the scatter plot, it should get filtered in the table. This is working fine. But if I place a slicer with some category value, For each slicer value selection,I will select some data points in scatter plot and I need all those selected values in the table. But if I change the slicer value, the previous values/rows in table is updated with new slicer value selection. Is it possible to retain the selected data points in the table for each of the slicer value selection?

Thanks,

Priyanga

[v-diye-msft · Accepted solution]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is,kindly mark the helpful answer as a solution if you feel that makes sense. if not, please share more details about your question, I'd like to provide further support. thanks!

[v-diye-msft]

Hi @Anonymous ,

Do you mean you'd like to keep the filtered vasual in table by scatter plot, and then filter also by slicer value? it seems like set the OR condition between the sctter filter with slicer filter. right?

I think you can manage the value in scatter plot as another slicer, and then add the dax measure. below detailed blog for your reference.

https://www.sqlbi.com/articles/using-or-conditions-between-slicers-in-dax/

If you'd like to keep the filter by scatter plot as well as the slicer in "AND" condition, that would be easier. manage 2 slicers, and filter the table.