Data entry fields

[DanCasSan]

Hello community:

I have a question, can a field be enabled in a published report of Power BI for the user to enter data and this is used as a variable?

Let's say that, I have the price and the margin with certain fixed values ​​and these must be operated with the data that the user enters, just as shown in the attached image (the price and margin values ​​are multiplied with the Input field). It should be noted that this data is unique, so when a new data is entered, everything previously entered must be deleted.

I will appreciate your advice or guidance on how I could do this.

Thank you!

Best regards,

[MFelix · Accepted solution]

Hi @DanCasSan,

You should use a Whatifanalys that allows you to have a parameter for user input, be aware that this is a table with the values you define so it can be from 1 to 100 having values from 5 to 5 (20 rows) or another setting like 0 to 1 with increments of 0.01 this will give you 100 rows.

Then just use the measure created automatically to get the calculation for example look at the PBIX file attach and the documentation on what if analysis.

https://docs.microsoft.com/en-us/power-bi/desktop-what-if

In my example I made a table from 0 to 5 with  increase of 0.5 so you can go above the price or below the price. you can also set negative values on the parameter.