Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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?
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!
Hi
I have just made the custom input slicer using "What if Parameter" for user input. My range in this is 1 to 35000. But when i am typing for example 5000 and entering it, it take 4996. Or may be 1000 then it taken value 993 or entered 10000 then it only comes to 9991. What can be the issue? How can I solve this minor error?
I am calculating the ROI so minor fluctuation can add to big problem.
Kindly revert.
Thank you
Hello.
Were you able to solve this issue? I have the same problem.
Thank you
Hi @irmarymorales,
Parameters can only contain 1,000 unique values in their range. Power BI will generate its own evenly sampled intervals to fit within the constraint if too many intervals exist. The solution, as per the linked document, is to use a suitable interval value that ensures that Power BI does not need to do this.
Regards,
Daniel
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Yes, there is. There are two options:
Let me know if you have any furhter questions.
Ignat Vilesov,
Software Engineer
Microsoft Power BI Custom Visuals
Hi @v-viig
You mentioned Use HTML input element. How to do that? And also I am not getting the second option either. Can you help?
Hi there!
A few years later, are there any other options available yet? I also tried to alter the parameter
User | Count |
---|---|
15 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
16 | |
11 | |
5 | |
4 | |
3 |