Forum Discussion
::: How create a simple calculator for the user to input values :::
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 😁
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:
6 Replies
- MFelix
Super User
Hi Anonymous ,
You can create the what if parameters:
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
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
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:
- hashtag_pete
Helper V
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
