I’m trying to create a Clear Button in Tableau to reset a multi-select filter for a field called list. I followed the steps to create a parameter and a calculated field to clear the selection, but it is not working as expected. When I click the Clear Button, the parameter changes from blank to "Reset" but the filter does not clear.
- What I Have Tried Step 1: Created a Parameter Name: Reset List Parameter Data Type: String Current Value: (left empty)
Step 2: Created a Calculated Field IF [Reset List Parameter] = "Reset" THEN NULL ELSE [List] END
Step 3: Applied the Filter I dragged the List Filter Reset calculated field to the Filters Shelf in my List Filter sheet.
Selected All Values.
Step 4: Created a Clear Button Created a calculated field called Clear: "clear"
Dragged it to the Text Mark card and formatted it as a button.
Step 5: Added Parameter Action Went to Dashboard → Actions → Add Action → Change Parameter
Configured it as follows: Source Sheet: Clear Button Target Parameter: Reset List Parameter Field: Clear Set Value To: "Reset"
Expected Outcome When I select multiple values from the List filter and click on the Clear Button, I expect all selections to be cleared.
Actual Outcome The parameter changes from blank to "Reset" as expected. However, the filter does not clear. The selected values remain even though the calculated field should return NULL.
any help is highly appreciated, thanks in advance.