Loading
Salesforce から送信されるメールは、承認済ドメインからのみとなります続きを読む

Reset Multiple Set Filters to "All" Option with One Click

公開日: Dec 29, 2025
前提条件
Tableau Desktop
タスク

Standard reset buttons may not work as expected when using Set Controls as filters. This task involves creating a custom button using Dashboard Set Actions. By configuring the action to "Assign values to set," you can push all values back into the target sets, effectively resetting the filters to show "All" values.

For example, when using multiple set filters in a worksheet/dashboard, how to reset them to [(All)] with one click.

 

 

 

 

ステップ

Step 1: Create the Reset Button Worksheet

  1. Create a new worksheet.
  2. Create a calculated field with the string "Reset" (or similar) and place it on the Rows or Columns shelf to create a button-like appearance. Alternatively, use the Polygon mark type.
  3. Important: Drag the Dimension that is the source of the set you want to reset onto Detail on the Marks card.
    • Reason: This ensures that all members of the dimension are passed to the target set when the action is executed.

Step 2: Configure the Set Action on the Dashboard

  1. Place the created "Reset Button" sheet onto the dashboard.
  2. From the dashboard menu, select Dashboard > Actions.
  3. Select Add Action > Change Set Values.
  4. Configure the action settings as follows:
    • Source Sheets: Select the "Reset Button" sheet.
    • Target Set: Select the set you wish to reset.
    • Run action on: Select Select (recommended) or Menu.
    • Running the action will: Select Assign values to set.
  5. Click OK to save. If you need to reset multiple sets, repeat this process for each set or select all applicable sets if the version allows.

Step 3: Verify the Behavior

  1. On the dashboard, filter the view using the set controls.
  2. Click the "Reset Button" you created.
  3. Confirm that all values included in the Detail shelf are assigned to the set, returning the filter to the "All" state.

Please refer to the attached workbook and video for details.

ナレッジ記事番号

005232631

添付ファイル

reset set filter_Final.mp4

3979 KB

Clear Set Filter.twbx

1210 KB

 
読み込み中
Salesforce Help | Article