CODEWITHSUNDEEP
tableau-api
liminche
liminche

Reputation: 271

Tableau: how to build cascading parameters?

Just see as following image

enter image description here

what I want to realize is, when I choose a specific area in the Area dropbox, The Block dropbox only shows the content which only belong to the selected area. How to realize that in tableau? Area and Block are both parameters.

Upvotes: 2

Views: 8745

Answers (2)

Alex Blakemore
Alex Blakemore

Reputation: 11896

Filters can cascade in Tableau if you select the "Relevant Values" option on the quick filter. (see the little black triangle in the top right of the quick filter).

You may want to also put the two fields into a hierarchy to teach Tableau that Blocks are subordinate to Areas, but Tableau will try to show only relevant values even if you don't define the hierarchies explicitly. To make a hierarchy, drag fields on top of each other in the data pane on the left.

There is no concept of relevant values for parameters currently. Each has an independent range of values. Parameters are not tied to a data source.

Upvotes: 0

jai
jai

Reputation: 126

I would advice you to use filter. then for the block filter,click the arrow on the top right and select "Only Relevant Values".The block filter will then refresh after you choose an area to show only the blocks related to that area. For parameters currently the dynamic refresh feature is not present, though it is being demanded.

Upvotes: 2

Related Questions