End users changing table values (dynamically changing data)

[justinMcC]

Hi,

I have a product table in a report.

On the product table I want the end user to be able to set and change the product dosage. The values range from 0.1 to 1.0 eg,

PRODUCT NAME       DOSAGE
Product 1                   0.9
Product 2                   1.0
Product 3                   0.8

I want to end user to be able to select a product and set its dosage, then select another product and repeat the process. Ideally I would like the product and dosage to be stored on a table. How can I do this on a published report?

Thanks for your help it is much appreciated

[v-caliao-msft · Accepted solution]

@justinMcC,

Power BI is used for data visualization. Generally, we cannot add custome value on the report and then save it into a table or database. If you would like this feature, you could use PowerApps. Please refer to the link below to see the details about PowerApps.
https://powerapps.microsoft.com/en-us/

Regards,

Charlie Liao