Forum Discussion
Dynamic change on values between slicers
Hi,
Please Help.
I have a set of values from measures which displays correctly .
But I also want to display another slicer or check box so as to flip between this values and the multiple of this values in the same graph.
I want to have a slicer/check box to swing between the original values and the multiple by using another slicer/chekbox.
For now, I am multplying all the values by 0.05.
Not sure if I full understand, but I think what you are asking for can be solved using a parameter.
Under Modelling tab, click "New Parameter". Change it to a decmial and fill in appropriate fields. You would need the increment of at minimum 0.05 for this example.
You can then create a new measure:
New Values := [Your Measure Values] * [Parameter Value]
Note: this will give you a slicer allowing many multiples, depending on the incement and min / max you select. If you wanted just a filter with two values, you can fill in like so:
You can then change the filter type to LIST.
I think this is what you are asking, please let me know if not.
2 Replies
Not sure if I full understand, but I think what you are asking for can be solved using a parameter.
Under Modelling tab, click "New Parameter". Change it to a decmial and fill in appropriate fields. You would need the increment of at minimum 0.05 for this example.
You can then create a new measure:
New Values := [Your Measure Values] * [Parameter Value]
Note: this will give you a slicer allowing many multiples, depending on the incement and min / max you select. If you wanted just a filter with two values, you can fill in like so:
You can then change the filter type to LIST.
I think this is what you are asking, please let me know if not.
Hi Steve,
Thank you so much.
Your Below solution worked perfectly...:
Click the Parameter table, and cheange the table function to:
Parameter = GENERATESERIES(0.07, 1, 0.93)
""Make sure the parameter column is a format of decimal.
If you wanted to have the filer to have a name indstead of a number, you could add column:
Filter Values = if(Parameter[Parameter]=1,"Original","Multiple")
Change the green names to what you want.
Use this new column (or the original parameter column if yu want to display the numbers) and add to a slicer, and set the type to a list.
Check out the chiclet slicer from the store for more options on the slicer layout.