Forum Discussion
One Slicer, multiple Parameters
I think I got your issue now.my last try.check this
You have to bring value4 to fields for the slicer and for the y axis of the graph do below,
I hope this works
regards,
Hi,
I believe you have manually written this to generate a field parameter.Here is how you should do it.
Go to Modeling Tab->New Parameter->Field
Then do as below screenshot,
Then Click on "Create" Button.Your field parameter will be available to use and it will automatically generate the slicer also.
correct syntax for the field parameter is shown below.But do not write it manually instead follow the above steps.
But this will only make it possible to switch between the 2 sales measures. I want to display BOTH sales measures or BOTH revenue measures in a stacked bar chart for example.
Hi,
For that first create the Field parameter with all 4 measures as explained before.
That will result a slicer looks like below,
and then in slicer settings disable mutli selction with Ctrl
you will be able to easily select whatever the measure/measures you want.
No that wont do it either Im afraid. But thank you so far anyway. In the end it want a slice with 2 options "Revenue" and "Sales". When I select Sale my barchart shows the two sales measures and when I select Revenue its the 2 revenue measures.
My example with 4 measures is just to simplify. In reality I have 6 or 8 measures per option and I dont want the user to be able to mix them or to be obliged to select each one, one by one...
I think I got your issue now.my last try.check this
You have to bring value4 to fields for the slicer and for the y axis of the graph do below,
I hope this works
regards,