Forum Discussion

shoaibalvi's avatar
shoaibalvi
Helper I
2 years ago

selecting data to export from table

Hi all,   I have a dashboard which has several visualisations, and in the end there is a Table visualisation which basically reflects the raw data on which the earlier visualisations were based on....
Need Help
danextian's avatar
danextian
Super User
2 years ago

Hi shoaibalvi ,

 

You can make use of RANDBETWEEN to add random numbers in a visual and then use parameters to set the number that should be visible.

Random Numbers Filter = 
IF (RANDBETWEEN(1,1000) <= [Parameter Value], 1, 0 )

Please see attached sample pbix

shoaibalvi's avatar
shoaibalvi
Helper I
2 years ago

Hi  danextian 

Thanks for taking the time to respond! 😃


However, I am not sure the solution offered would achieve the desired result. What I wish to do is allow users to select data rows in the table visualisation and add comments as to why they selected those rows. I need power BI to them "remember" these selections, even if other connected visualisations are changed, and then allow users to "export" their selections to excel in the end. 

 

To help with the context, the dashboard is for auditing purposes, and allows auditors to manipulate visualisations based on varying risk factors. With each interaction of the visualisations, the data table at the end of course changes and updates. Now I am looking for this final step where they can make final selections in this data table and export the samples for testing at the end. I wonder if that would work?