User selectable Yes\No column

[lfk32]

I have an existing table that I want to add a column to for a Yes\No response.  Initially the field will be blanks.  I add that field to the report in which a perosn viewing the report can select either Yes or No which is then written to the table.

When doing a fresh import of the data anythign that is already in the table will keep the yes or no and anything new from the import will start with a blank field.

How can i do this?

[rubayatyasmin]

Hi, @lfk32 

I can think of 2 ways. 

1. Use power apps integration in Power BI. 

• for that you need a column that can hold yes, no and blank values.
• then in power apps create a form wich will take values from user
• integrate it with power bi

2. use field parameter. 

here is the documentation you  might want to follow. Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn

[TomMartens]

Hey @lfk32 ,

basically, this is not possible because Power BI does not allow users writing to data of the data model.

You can think of provididng users with a Power App that creates this column to the datasource, of course this requires a datasource that allows data change or you have to create a solution that stores the Y/N together with an identifier an then combine this when importing the data to Power BI.

Regards,
Tom