Drop-down Sheet Selector & Dynamic Zones, s1096 - Learning Objectives
Learning Objective
The implementation of Parameter Controls combined with Calculated Field Filters to create a dynamic "Sheet Swapping" effect on a dashboard.
Technical Focus
Parameter Creation: Defining a string-based list parameter (e.g., "pSelect a Sheet") that contains the exact names of the worksheets to be toggled.
Logical Filtering: Constructing a calculated field that passes the parameter value to the Filters shelf, allowing a worksheet to display only when its name is selected.
Custom Value Lists: Using the "Custom Value List" feature within the Filter dialog to manually input the specific sheet name for each toggle state.
Dashboard Real Estate Optimization: Using Floating objects to stack multiple worksheets in the same physical space, which allows the dashboard to seamlessly switch between views like "Sales" and "Profit" without requiring additional screen space.