Forum Discussion
Changing Data through slicer
I would like to create new data based on a slicer setting i have chosen linked to a parameter values. For example, i have a baseline monthly forecast for 2022. I would like to apply a percentage ch...
Hi dmartiprev ,
Here are the steps you can follow：
1. Create calculated table.
Table 2 = GENERATESERIES(0,1,0.01)
2. Create measure.
Adjusted Forecast =
var _select=SELECTEDVALUE('Table 2'[Value])
var _sum=SUMX('Table','Table'[Baseline Forcast])
return
_sum*( 1+_select)3. Result:
Take [Value] as the slicer.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly