12-06-2018 02:32 PM
Is there a way to have a numeric box that users can enter a value into that will be added to other values?
We will be displaying data grouped by month, and we would like to have a field that they can enter a numeric value into that will adjust the monthly value.
I searched the forums and couldn't see anything like this?
12-06-2018 03:13 PM
Under the Modeling ribbon, there is a feature called a "What If Parameter". This will allow your users to input a number of custom values into the report, including whole numbers, decimal numbers, date/time, and TRUE/FALSE. It also creates a variable that you can utilize in other areas across Power BI. This variable allows you to utilize the user input value in measures, as fields/filters for visuals, etc.
Click on "New Parameter" and a dialogue box will open up that allows you to customize your parameter. Additionally, once you've added the parameter to your report, you can click on the "Parameter" field and it will display some additional formatting/property options in the Modling ribbon.
Let me know if this works for your report and if you need any additional help!
12-06-2018 10:48 PM