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
HughLa
Resolver IV
Resolver IVI would suggest using a measure here, because you are using a what if parameter which is meant to change, and a calculated column which is static won't work.
Thank you so much