Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to Solution.
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
@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,
Josef
Hi,
Combining PowerApps with direct query mode allows instant update of a visual with data written to the source via the powerapp.
Cheers,
Sturla
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
97 | |
94 | |
74 | |
71 | |
64 |
User | Count |
---|---|
143 | |
109 | |
103 | |
82 | |
74 |