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 HughLa ,
I tried your above method and got the default value of the slicer sorted, but when i change th evalue of slicer, it does not change the SELECTEDVALUE part of the parameter. I have set the default value as 465000.
The selected value still remains to be 465000:
Why is it not changing to the current slicer value? Am i missing something?
Thanks!
Resolver IVHi 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.
- HughLa
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?