Store Slicer Data

[motleyts2]

Hi. What is the best solution for this Cybersecurity Proof of Concept? For a Single "Threat Type", I want to provide an answer for each criteria listed in the image in Power BI Desktop. I want each slicer value to be stored (i.e, a table, list, sheet, etc). Once all threat types have all criteria answered, I will build a visual from that data. Should this be accomplished with a Power App (input data)? Power Automate (trigger a flow to move data to excel sheet)? I am open to ideas. Thank you.

[MFelix · Accepted solution]

Hi @motleyts2 ,

Power BI is a visualization tool and the options for saving inputs from the user exist but are not direct.

In your case I can see a couple of options (some of them you already refer):

• Power Automate to trigeer a flow to save information on sharepoint, excel, ...
• Power App but this would be a input app and you would have to redo your "slicers" on that app
• Writeback feature using a custom visual (https://appsource.microsoft.com/en-us/product/power-bi-visuals/xviz.inforiver-enterprise?tab=Overvie...) that will allow to have input fields in your table

[Anonymous]

Hi @motleyts2 

I don't quite understand your needs. Do you want a visualization to be automatically generated when the data satisfies all slicers in the screenshot?

Best Regards,
Yulia Xu

[motleyts2]

Essentially, yes.