You almost have it. Just a couple of issues.
First, on the Reset Button tab, you'll need to remove the global filters. You don't want these applying to this sheet:
Second, edit Filter actions 1-4 so that they do not apply to the Reset Button sheet.
Finally, edit the reset action filter so that Global Filter is included in the target and Reset Button is not.
See attached workbook.
If this assists in resolving your question, please mark my response as the 'correct answer'. This will help other users with similar questions. Thanks!
Clear Filter.twbx 8.2 MB
Create reset button
Drag this in shape and row.
Set action filter with state,all filter values in selected field.
When you add year or month filter then use the year(Orderdate) and month(orderdate) then only reset will work.
Now select any state in map and select any values in filter and then reset it.
All works well.
Clear Filter.twbx 8.3 MB
1 of 1 people found this helpful
Any further questions on this, Grace? If not, would you mind marking one of the responses as the correct answer so others with similar problems can learn from it in the future? Thanks!
Thanks you so much for the solution ..I can see "ALL" in the filter when I click the Reset Button...
Is it possible to clear the map action filter too... For example., If I click on 'California' from the map ..it is changing Category and Sub category based on the state... so when I click on Reset Button, it should also be cleared... and show all category and sub catefory data...
Please give me solution..
I got fixed it by adding the state column from the( selected Field) (For the Map graph) into Reset Action Filter ... Thanks eveyone...
Great! Would you please mark one of the answers as the correct answer so we can close this one out and so others with similar questions in the future can learn from it. Thanks!