Reference bands are already dynamic, though I don't think there's a way to enable/disable them through a quick-filter selection. If you'd like to be able to turn them on and off, I would create a parameter for turning the bands on/off, then create a calculated field with a CASE statement to return the values when the parameter is set to "on", then set the reference band to use the new calculated field.
Hope that helps!
Thanks! Maybe I should give more detail. I have 5 reference bands on the
sheet, all constant, in order to show the dates when Congress was in
session this year. We have a quick filter on the sheet so that people can
narrow down the dates, and I'm hoping to find a way to make the bands
appear or not based on the dates shown in the window at any given time.
On Fri, Apr 25, 2014 at 12:59 PM, Jordan Bunker <