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
Hi Anonymous
That is strange that it is not changing.
I just tested it on my side and it changes to the selected value in the slicer. Maybe try playing around with the default value.
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.
Hey 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?What is it exactly that you are trying to achieve with the calculated column? Would you not be able to use a measure instead?