::: How create a simple calculator for the user to input values :::

[Anonymous]

Hello pls!!

If you can help me... 🙄
Is there any way I can insert an object for the user to manipulate on the screen?

Example:

I wanted to create two objects for the user to input values ​​and a third object that would make a sum of the two objects (by the values ​​informed by users)

I would like to create a calculator, where the user enters the value and receives the result in a card 😁

[MFelix · Accepted solution]

Hi @Anonymous ,

This is a know error on the type of slicer of the parameters especially with big numbers one option can be to do to add a column with the same values of parameters but on text format. Sort that column by the parameter and change the slicer to a selected list with single select.

Then turn on the search option on the slicer:

[Anonymous · Accepted solution]

hello Guys!

Tks for help me!

But I need anything better, that the user can interact. 

At Excel, is easy... I'll do a UserForm with a "TextBox" where the user can interact, with any number... here in Power BI with long numbers gives error 😅

[hashtag_pete]

Hello opl12, 

not quite sure what you're trying to achieve, but I just tried something that might help you. 

if you have the numbers you want to calculate in columns, than you could use the visual "Text Filter" and use SELECTEDVALUE to calculate those numbers.
Example:

Column 1: contains prices

Column 2: generated with numbers from 1-1000000

2 Text filters (each for one column)

2 SELECTEDVALUE measures, that get the values the user types into the text filters

1 measure to multiply, add, divide, ... the 2 SELECTEDVALUE measures 

Could you follow my idea? A bit strange, I know, but it works like a calculator 😄

best

hashtag_pete

[MFelix]

Hi @Anonymous ,

You can create the what if parameters:

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

[Anonymous]

Thanks @MFelix ,

I saw this, but when the number range is quite high ... it does not work well,

example: I put an initial range from "0" to "100,000"

if the user types any integer into the text box of the object and typing "enter" the number changes,.... example, if I type "99" and enter.. the value changes to "100".

the range range is already at "1" as shown in the formula... is there any way to fix this?

[MFelix · Accepted solution]

Hi @Anonymous ,

This is a know error on the type of slicer of the parameters especially with big numbers one option can be to do to add a column with the same values of parameters but on text format. Sort that column by the parameter and change the slicer to a selected list with single select.

Then turn on the search option on the slicer:

[Anonymous]

HI @Anonymous,

Yes, this should be a known issue when you use a big number input to what-if parameter filter. It will auto redirect to the nearest number of the slide bar located.

For this scenario, you can change the slicer to the range mode(before, after) and this issue will disappear.
Regards,

Xiaoxin Sheng