1 of 1 people found this helpful
I don't know of any way to dynamically limit parameter options. One workaround that will work across data sources is to use a Filter Action. You could have the Indistry done as a parameter, and then have that filter across your data sources and also filter an additional worksheet that shows the Segments for the chosen parameter. That worksheet would have a Filter Action that applies across all worksheets on the dashboard (you can set that up with the "Use as Filter" option from the worksheet's menu on the dashboard).
Thank you a lot Jonathan, it works and the solution is quite simple !!
Just to be sure, in my dashboard i have two worksheets, but none have the segment field, to implement your solution I need to add a third worksheet with the segments' names (filter by the Industry parameter)?
Anyway, thank you for your quick answer!!
Yes, you'll add the third worksheet and then set up the Filter Action.
Hope you are doing good, Is there any way we can get the value of the selected item filter so that depending on that I can get relevant values in another filter.
It's not possible to get an only relevant values view of a parameter. There are two ways you can show only the relevant values:
1) Use the Only Relevant Values option on a quick filter.
2) Use quick filters or Filter Action worksheets (i.e. a worksheet that is built to be used as a source for a Filter Action that then targets other worksheet(s)) that target a Filter Action worksheet. The second Filter Action worksheet is then filtered by the prior selection.