Forum Discussion
User can select value from dropdown and update table
Hi Team
I'm looking for option where user can select value from dropdown and select value for that table.
Since Power BI is a SAAS solution we can't add/edit/delete the data directly from Power BI. But you can use Power Apps in Power BI to write back to the source.
Please refer this video - https://www.youtube.com/watch?v=5y2jJyH4Eu0
Thanks for the reply from Arul , please allow me to provide another insight:
Hi adityavighne ,
According to your description, when clicking on the refresh button in powerbi, you can synchronize the updated results in the excel sheet.
But changing the status directly in powerbi can only be done by creating a filter condition in the formula.
status_ = SWITCH ( SELECTEDVALUE ( Sheet1[Name] ), "A", "yes", "B", "no", "yes" )Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Your ask is not clear to me. Could you explain it more in detail?
Arul I have excel connected to power bi. Now i want to give option to user so they can change status of that contact in Power BI. for example staus for A is 'Yes' but tomorrow if user want to change from Yes to 'No' then he can make those changes in Power BI.
Since Power BI is a SAAS solution we can't add/edit/delete the data directly from Power BI. But you can use Power Apps in Power BI to write back to the source.
Please refer this video - https://www.youtube.com/watch?v=5y2jJyH4Eu0
I think he means that the user want to change the data of the data source in power bi itself, then give him access to the excel.
Thanks for the reply from Arul , please allow me to provide another insight:
Hi adityavighne ,
According to your description, when clicking on the refresh button in powerbi, you can synchronize the updated results in the excel sheet.
But changing the status directly in powerbi can only be done by creating a filter condition in the formula.
status_ = SWITCH ( SELECTEDVALUE ( Sheet1[Name] ), "A", "yes", "B", "no", "yes" )Best Regards,
Adamk KongIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
