Behavior of a measure on different shelves

Let’s put some data into excel and import it into Tableau.


We will set Year and Month as Discrete Dimensions and Sales as Continuous Measure. Now we will put these fields into different shelves in Tableau.

Year in Columns and Month in Rows forms a crosstab with missing values in the body so Tableau enters Abc instead.


When we drag Sales into Rows we will get a mini bar chart for each dimensions value.


When a Sales measure is put on a Color shelf then we have this view.


On a Size shelf.


On a Text shelf.


On a Tooltip shelf.


On a Detail shelf we see that there is no change to a table besides that the measure values are showing up in a tooltip. As well as when we copy data from the table the measure values will be included.




Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s