I tried to use this approach, but the sticking point for me was making the value of the parameter dependent on the value of the filter. I do not want to add a drop down to my dashboard, but rather would like to have the value of the parameter automatically change based on the selected value of the filter
Nick, I wish I could do that too, but sadly, parameters change filter values and not vice versa.
Having said that, though, what is preventing you from using JUST the parameter instead of the filter? You don't have to show both the filter AND the parameter.
My dashboard is displaying 5 worksheets, and the filter is tied to all 5. I'm only looking to have one of those worksheets pivot based on the value of my filter, and have the other 4 simply filter down rather than shift worksheets all together.
Are you saying I could replace my filter with a parameter, and have the 1 worksheet pivot which worksheet is displayed, while the other 4 worksheets will simply filter down based on the parameter's selected value? Could you help me understand how to do that?
Well, it may be a little complicated to figure out but I'm up for a challenge!
So the rough architecture of the dashboard is like this:
1) One sheet-swap viz where you want to change the viz based on the value your user selects.
2) 4 vizzes that you simply want to filter based on the the value your user selects
Is that right?
For the sheet-swap, are you swapping pills on the Row & Column shelves, or are you showing/hiding 3 different vizzes?
You've got it. 4 vizzes that will simply filter based on the parameter value and 1 viz that will sheet swap
The sheet swap is technically the exact same sheet duplicated three times, but with the center value on the color legend for each sheet changed. All else is the exact same among the three sheets that will be swapping