Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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?
Solved! Go to Solution.
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.
I have insert thie new column:
#Column = VALUE('Forecast (Billing)'[Billing])*'Autodesk New'[Autodesk New Value]
I don't understand what you mean. Can you explain to me what do you want to do with the new column?
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?
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
In the measure of the paramter table you have the following formula
can anyone answer to my questions?
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.
User | Count |
---|---|
84 | |
71 | |
71 | |
68 | |
55 |
User | Count |
---|---|
94 | |
92 | |
91 | |
77 | |
70 |