User can select value from dropdown and update table

adityavighne ,

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 Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.