Forum Discussion
Store Slicer Data
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.
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=Overview) that will allow to have input fields in your table
3 Replies
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=Overview) that will allow to have input fields in your table
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 XuEssentially, yes.
