User input data from Dropdown

[thegeneral1]

Hi All,

         I have created a simple power BI data only table - but i need another column that a user can either select "Keep" or "Remove" using a dropdown, for each row. These values would also need to be copied down.

This report will be located on Power Bi Server that will allow 20 stakeholders to either select "Keep" or "Remove".

I appreciate any help that you can give

Thanks

[thegeneral1]

Is this type of sceneraio even possible on Power BI?

[v-easonf-msft · Accepted solution]

Hi, @thegeneral1 

Power bi did not include any writeback features, you can't direct save changes and writeback these result.

For your requirement, you can consider creating a PowerApp for input and submit operation.

Power BI enables data insights and better decision-making, while Power Apps enables everyone to build and use apps that connect to business data. Using the Power Apps visual, you can pass context-aware data to a canvas app, which updates in real time as you make changes to your report. 

Related documents:

PowerApp_control-drop-down 

PowerApps-custom-visual 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@thegeneral1 ,The information you have provided is not making the problem clear to me. Can you please explain with an example.

Appreciate your Kudos.

[thegeneral1]

Hi

Very simple example below

Col A:D is the data coming from Direct Query DB.

Col E2 is blank but with selectable dropdowns ie. Keep or Remove.

A User that visits the power BI table can input whether to Keep or Remove

Hope this is clearer??

Thanks