Parameters do not currently support the ability of having one parameter impact the set of values available in another parameter. Filters, on the other hand, do support this feature. I'd be interested to know if filters could work for your solution here? If not, we would like to understand why. Usually this is due to a requirement to do cross data source filtering, or you might be using this date as part of a calculation.
I agree with Sean after looking at your workbook--you should be able to use quick filters to accomplish what you want. Quick filters will also be dynamic--when new records are added, they'll update when refreshed. They also allow you to use various single and multi-select options that are not available for parameters. We're all hoping for dynamic parameters sooner than later, but for now, they are static.
Here's a version 8.1 workbook that demonstrates using 2 quick filters with "only relevant values" set on the M/D/Y filter to accomplish the same. If you don't have 8.1 installed, you can install multiple versions simultaneously, assuming your licenses are up to date.
Filters will help out. But my requirement is different where i cannot use filters.
Consider the data to have multiple events and the report compares across 2 sets of events.
So let us say Sales of Event 1 has to be compared with sales of Event 2, i cannot use a filter on the events.
I will post few more graphs in the workbook which i am facing the issue.
Please do mock up an example of what you are describing, as I'm not clear on the point you're making here.
I'll be happy to take a look if you can demonstrate the issue--in the meantime, some users are using this "popping parameters" article as inspiration for creating unique parameter-filtering scenarios:
Instated of Using dynamic Parameters we can use cascading filter then achieve this . Have a look on attached TWXB File .Just refer Result Tab. Let me know if any concerns..
Dynamic Parameter inputs1.twbx 12.6 KB
I believe this is the same approach I posted earlier.
Attached is the workbook. I am trying to compare across holiday events and the 3rd and 4th graphs in the dashboard restricts me from using Filters.
To perform calculation on the metrics like difference in sales of the 2 events selected, i am in need of using parameters rather than filters.
1)Are the above calculations possible using multi-select filters? If possible then how.
Currently i have selected, Event 1 and Event 2 as Christmas 2013 and 2014.
Is it possible to get the 3rd and 4th graphs via multi- select filters?
Like, Event 1 -->Christmas 2013 and Christmas 2014
and Event 2--> New Year 2013 and 2014.