Parameter in Tableau — Using available Dimension with additional ‘All’ for all data
I am writing (and still writing as of this article) a manual to assist me in teaching Tableau. One of the sections is Parameter. There are many examples and guidance provided by Tableau.
You may read/view the following articles/videos for the guide on parameter.
1. https://interworks.com/blog/interworks/2012/03/26/how-to-create-and-use-parameters-in-tableau
2. https://help.tableau.com/current/pro/desktop/en-us/parameters_create.htm
3. https://help.tableau.com/current/pro/desktop/en-us/changing-views-using-parameters.htm
4. https://www.youtube.com/watch?v=CrfEJ24FWpQ
The only problem I faced was to have an ‘All’ data if the user did not select any or wishes to see all data. None of them help. I tried using Action and Filters, yet it only shows based on selection and all show nothing.
That is until I found this solution.
In a more readable, it will be like this
Step to:
- Create your parameter — In this case, you use any Dimension as the Parameter by choosing a List and choose the list by changing the Fixed section and click on Add Values From.
- Don’t forget to add ‘All’ as one additional list
- Drag the Dimension that you used as the parameter from the Dimensions Card into Filters Card.
- In the Filter option, choose Condition and choose By Formula, and insert the above solution into the formula.
- Don’t forget to change the [FilterField] to the Dimension used for the filter and the [Parameter] to your created parameter.
- Do ensure that ‘All’ is the same as your definition in the parameter (the character case and spelling is equal)
- And that shall do it. You are ready to go.
Thanks to the person posted here: https://tarsolutions.co.uk/blog/tableau-add-an-all-to-a-parameter/
There is also an alternative solution to this and posted here: http://www.vizwiz.com/2012/09/tableau-tip-adding-all-filter-option-to.html