Forum Discussion
Changing a parameter based on a slicer
Can I change a parameter based on the selected slicer value?
The parameter then is used to calculate a column displayed on the report in a table
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
10 Replies
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.
Drop Dead Miles Value = SELECTEDVALUE('Drop Dead Miles Cap'[Drop Dead Miles],465000)Irrespective of the change of value in the slicer as shown below:The selected value still remains to be 465000:
Why is it not changing to the current slicer value? Am i missing something?Thanks!
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