How to create a dropdown in dashboards

Question

How to create a "sheet selector" that allows you to select a single sheet from the control panel and replace all sheets with only the selected sheet.

+3

Karishma dudhbade 21 oct. 14 at 3:57

1 answer

Y.Prithvi · Answer 1 · 2014-10-21T08:37:36+0000

This workaround will work:

Select the create option (right click in the data window on the left).
In the options dialog, assign values as shown below:

Datatype: String
Possible Values: List
List of Values: All, Sheet 1, Sheet 2, ..
and give it a name
Create a calculated field (right click in the data window on the left)
Give the parameter name from step 2 in the formula text box.
For each sheet in the workbook, drag the calculation field you created in step 4 to the filter shelf and do the following:
- in the general tab, select a custom list of values
- enter All
  
  in the text box and click the Add Item button. enter a name for the specific sheet and click Add Item.
create dashboard
Right click on the sheet and select Parameter

→ Select a sheet

. You can find a new filter added to your right side and you can choose which sheet to show in the toolbar.

Link