I'm not sure what you mean by "hide the parameter". Do you mean that you want to remove the parameter control for Parameter B, if a certain selection is made in a different parameter (Parameter A), or do you want to remove some options from Parameter B, depending on the selection of Parameter A?
It is possible to create a "sheet selector" to hide controls using a floating worksheet. You can find more information on that solution here:
Please let me know if this does not address your issue!
Thanks you very much for your kind information. As you have already
explained the problem which i need to solve is that I want to remove the
parameter control for Parameter B, if a certain selection is made in a
different parameter (Parameter A).
Consider this example, where Parameter A has two drill down values. First
one as "Last 4 Weeks" and the second one "Custom date". There are two
parameters like "Start Date" and "End Date". So, In Parameter A, if i
select the value as "Last 4 Weeks" then my other two parameters "Start
Date" and "End Date" should be hidden in the dashboard. When i select
"Custom Date" in Parameter A then both "Start Date" and "End Date" should
Let me know is there any solution to solve the above mentioned problem in
Anyway, Once again thank you very much for the details.
On Sat, Mar 25, 2017 at 3:16 AM, Sara Sparks <firstname.lastname@example.org>
I think that Jonathan Drummey's solution on this thread is what you're looking for:
There is an attached workbook which demonstrates his solution.