topic Re: Custom visual numeric input box? in Developer

Custom visual numeric input box?

danjdo — Thu, 06 Dec 2018 22:32:18 GMT

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?

Re: Custom visual numeric input box?

Anonymous — Thu, 06 Dec 2018 23:13:02 GMT

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!

Re: Custom visual numeric input box?

v-viig — Fri, 07 Dec 2018 06:48:26 GMT

Yes, there is. There are two options:

Use HTML input element
Use Format Panel

Let me know if you have any furhter questions.

Ignat Vilesov,

Software Engineer

Microsoft Power BI Custom Visuals

pbicvsupport@microsoft.com

Re: Custom visual numeric input box?

Anonymous — Wed, 25 May 2022 02:50:02 GMT

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

Re: Custom visual numeric input box?

Anonymous — Mon, 05 Dec 2022 16:20:28 GMT

Hi there!

A few years later, are there any other options available yet? I also tried to alter the parameter

GENERATESERIES with measures ([costprice -100] and [costprice +100] to reduce the range and keep it under 1000 values, but it did not return the correct costprice values. Does anybody have new ideas to have a numeric input field?

Re: Custom visual numeric input box?

Cortana — Mon, 08 May 2023 09:46:56 GMT

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?

Re: Custom visual numeric input box?

irmarymorales — Wed, 20 Dec 2023 15:08:42 GMT

Hello.

Were you able to solve this issue? I have the same problem.

Thank you

Re: Custom visual numeric input box?

dm-p — Thu, 21 Dec 2023 00:01:13 GMT

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