Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

::: 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 ​...
Need Help
Show and Tell
Tips and Tricks
  • MFelix's avatar
    MFelix
    5 years ago

    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's avatar
    Anonymous
    5 years ago

    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's avatar
hashtag_pete
Icon for Helper V rankHelper V
5 years ago

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