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
I cant really say the exact thing I'm calculating, but for simplecity sake, say the table has columns A, B (a numeric), C and so on..
I want the calculated column to be = Slicer Value - Column B
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