Forum Discussion
Changing a parameter based on a slicer
Hi Anonymous
You will be able to create a numeric range parameter with which you can change the value with a slicer.
You can use that value within a measure or calculated column.
Here is an example:
This table is automatically created (with one column and one measure):
This measure returns the selected value of the slicer which you will use in your formula.
Hope this helps you.
Hugh
Ok I dont know how or why but, the parameter value is updating now.
But I'm using this value to calculate a measure (For a new column), this does not change though. Is there something I need to do? Refreshing after changing the slicer does not help either.
Resolver IVHey Anonymous
Are you using that measure in a Calculated column or a Measure? If you are using it in a calculated column it will have a static value and the slicers will not have any effect on the data.
Regards
Hugh
Currently using as a calculated column and yes its taking the static value (the default value)
Will it helpo if I use it as a measure and do the calculated column based on the measure?- HughLa
What is it exactly that you are trying to achieve with the calculated column? Would you not be able to use a measure instead?
I cant really say the exact thing I'm calculating, but for simplecity sake, say the table has columns A, B (a numeric), C and so on..
I want the calculated column to be = Slicer Value - Column B