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
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
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.