Forum Discussion

andmo's avatar
andmo
Frequent Visitor
2 years ago
Solved

Custom Parameter Changer from User

Hello Together,   is it possible to create a text input box that actively changes a parameter? For understanding: I have a table with values and this should be able to be changed actively by the ...
Need Help
Tips and Tricks
  • vojtechsima's avatar
    vojtechsima
    2 years ago

    Hi, andmo ,

    all right then, your Discount should be calculated as Measure.

    Like this:

    Discount = [Total Sum] * DIVIDE(SELECTEDVALUE(Parameter[Parameter]), 100)

    Please note that the selectedvalue except a column from your parameter table and it can have different name.

vojtechsima's avatar
vojtechsima
Super User
2 years ago

Hello,

I am not exactly sure what you mean. But you can have parameters bind with predefined text options, so whenever the user selects in the report the option will then proceed in the actual SQL Query.

 

Here's nice tutorial how it works:

https://www.youtube.com/watch?v=L-wqwzj0-Xo&t=270s