masteramuk
1 supporter
Parameter in Tableau — Using available D ...

Parameter in Tableau — Using available Dimension with additional ‘All’ for all data

Apr 14, 2020

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

5. https://www.youtube.com/watch?v=rJsaezoTVAE

6. https://www.youtube.com/watch?v=opfVV1maNVw

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:

  1. 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.

  2. Don’t forget to add ‘All’ as one additional list

  3. Drag the Dimension that you used as the parameter from the Dimensions Card into Filters Card.

  4. In the Filter option, choose Condition and choose By Formula, and insert the above solution into the formula.

  5. Don’t forget to change the [FilterField] to the Dimension used for the filter and the [Parameter] to your created parameter.

  6. Do ensure that ‘All’ is the same as your definition in the parameter (the character case and spelling is equal)

  7. 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

Enjoy this post?

Buy masteramuk a coffee

More from masteramuk