selecting data to export from table

[shoaibalvi]

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.

Users can work through the visualisations to isolate anomalies or transactions they want to investigate. In doing so, the data table updates (as intended) to show the underlying raw data rows.

Now I am wondering if its possible to allow users to select a sample of rows from this filtered data table, e.g., by somehow adding a little toggle in the end against each data row? 

The idea is that users could "check" a few rows as their samples to follow up on / investigate. When they do so, they possibly get an option to add the reason for selecting the data row. Once they are done selecting all samples, they may export the samples (along with their input reasons) in a spreadsheet to work offline / outside of PBI.

I don't know how complicated this would be, or if its even possible. But I am curious to know (and learn!)

Regards,

Shoaib

[danextian]

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]

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?