Forum Discussion
AlessandroBet
Helper V
Helper Vmultiplier
I need to moltiply the numbers inside a table selecting the multiplier from a "slicer" and also able to select the steps ex: 10.1, 10,2, 10,3 ...etc I have a table with the total revenue and i want...
Go to Modelling > New Parametr > Numeric Range and make sure to use "Add a slicer to this page". Your users can then use a slicer to select the percentage multiplier.
AlessandroBetHelper V
Helper Vmany thanks it works
I have other 2 questions
1) How can i make a moltiplication between the slider value and existing value?
2) Can i set the default value reading a measure?
stefani_vileva
Resolver II
Resolver II1. You create a measure in which you multiply every value with the value from the slicer.
2. What do you mean by setting default value reading a measure? Usually, you can take the minimum or maximum value of the slicer as default value.
- AlessandroBet
1. Ok
2. I would like to set the default value coming from other measure calculated
- stefani_vileva
In the measure of the paramter table you have the following formula
Parameter Value = SELECTEDVALUE('Parameter'[Parameter], Insert_your_measure).If you want a default value, you can put it as second argument of the function selected value.