User selectable Yes\No column

Question

I have an existing table that I want to add a column to for a Yes\No response.&nbsp; Initially the field will be blanks.&nbsp; 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.&nbsp;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.&nbsp;How can i do this?

tommartens · Answer

Hey&nbsp;lfk32&nbsp;,
&nbsp;
basically, this is not possible because Power BI does not allow users writing to data of the data model.
&nbsp;
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

rubayatyasmin · Answer

Hi,&nbsp;lfk32&nbsp;&nbsp;I can think of 2 ways.&nbsp;1. Use power apps integration in Power BI.&nbsp;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 userintegrate it with power bi2. use field parameter.&nbsp;here is the documentation you&nbsp; might want to follow.&nbsp;Let report readers use field parameters to change visuals (preview) - Power BI | Microsoft Learn&nbsp;

Forum Discussion

Related content

Yes / No Filter

Count of Yes/No

Yes or No Column

Yes/No matrix column based on if an item is included in a separate filter

How to: Percentage of "YES" in a YES/NO Column