Forum Discussion

SDAT's avatar
SDAT
Regular Visitor
7 years ago

How to record slicer selection in a database.

hi, 

 

I had created a pbix for user to select the product using slicer.

is it possible to record the selected product and save as a history database with timestamp?

 

ProductIDProduct
1apple
2banana
3orange
4durian

 Product table with slicer for user selection.

 

Desire output of the history database would be as such:

 

Selecting Date/TimeProduct Selected 
29/9/2018 07:34pmapple
29/9/2018 07:34pmbanana
30/9/2018 11:22amapple
30/9/2018 11:22amorange
30/9/2018 11:22amdurian
30/9/2018 1:34ambanana

 

I only able to find dax to obtain the current selection using measure but i cannot create table and save it. 

 

measure = 

if (

    isfiltered(table1[Product]),

    concatenatex(table1[Product]),table1[Product], ",",

    All()

)

 

anyone please help.

Thanks 

Need Help

1 Reply

  • v-frfei-msft's avatar
    v-frfei-msft
    Community Support
    7 years ago

    Hi SDAT,

     

    Based on my test, it is not possible to meet your requirement currently. You can come up a new idea about that and add your comments there to improve Power BI and make this feature coming sooner.

     

    Regards,

    Frank