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
Resolver IVWhat is it exactly that you are trying to achieve with the calculated column? Would you not be able to use a measure instead?
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
- HughLa
I 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