Forum Discussion
multiplier
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 calculate the margin selecting the value (%) from slicer
Can you help me?
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.
8 Replies
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.
many 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?
can anyone answer to my questions?
1. 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.
1. Ok
2. I would like to set the default value coming from other measure calculated
I have insert thie new column:
#Column = VALUE('Forecast (Billing)'[Billing])*'Autodesk New'[Autodesk New Value]
where "Autodesk New'[Autodesk New Value]" is the value calculated by slider but it does changeCould you help me?I don't understand what you mean. Can you explain to me what do you want to do with the new column?
