Forum Discussion
User selectable Yes\No column
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?
2 Replies
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,
TomHi, 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
