Forum Discussion
Enter data Lively - After creating a Column
Hello Community,
I have a column as below; I need to one more column “Comments” where I need to manually enter some text.
So, I added a Custom column with empty data as below:
Now I want to enter data in the Comments Column as below in the visual and get the report saved:
Name | Comments |
Orange | This may be a Fruit / Color |
Yellow | This is a color |
Apple | This is a Fruit |
Black | This is a color |
Grapes | This is a Fruit |
Are there any possible ways to achieve this?
Please help me po v-frfei-msft v-diye-msft sturlaws v-lid-msft JosefPrakljacic Nathaniel_C v-eachen-msft
Hey,
what you want is the writeback in the visual. Unfortunately this is not that easy. Either you use PowerApps as input mask (but then you can't write back directly in a table visual) or you use thirdparty providers like Acterys or PowerOnBi for the writeback.
This is not possible with PowerBI alone.
Best regards,
Josef
3 Replies
Anonymous , Create a column comment like
Switch([Name],
"Orange" , "This may be a Fruit / Color",
"Yellow" , "This is a color",
"Apple" , "This is a Fruit" // add more as per need
)Switch(true() ,
[Name]="Orange" , "This may be a Fruit / Color",
[Name]="Yellow" , "This is a color",
[Name]="Apple" , "This is a Fruit"// add more as per need
)
)Hey,
what you want is the writeback in the visual. Unfortunately this is not that easy. Either you use PowerApps as input mask (but then you can't write back directly in a table visual) or you use thirdparty providers like Acterys or PowerOnBi for the writeback.
This is not possible with PowerBI alone.
Best regards,
JosefHi,
Combining PowerApps with direct query mode allows instant update of a visual with data written to the source via the powerapp.
Cheers,
Sturla
