KNOWLEDGE BASE

Display Measures Dynamically


Product(s): Tableau Desktop
Version(s): 8.1, 8.0, 7.0
Last Modified Date: 16 Aug 2016

You can use Measure Names and Measure Values to set up a quick filter that swaps out the specific measures that are used in the view. For example, you may have a view showing Sales over time. You have another view showing Profit over time. Instead of maintaining these two on separate sheets, you can create a single view with a quick filter that lets you switch between showing Sales, Profit, and any other measure of interest.

Step 1 

Connect to a data source. This article uses the Superstore sample data source that comes with Tableau Desktop.

Step 2 

Drag the Order Date field from the Dimensions area in the Data window and drop it on the Columns shelf.

Step 3 

Drag the Measure Names field from the Dimensions area of the Data window and drop it on the Rows shelf.

Step 4 

Drag the Measure Values field from the Measures area of the Data window and drop it on the Rows shelf.

Step 5 

On the Rows shelf, right-click the Measure Values field on the Rows shelf and select Show Quick Filter.

Step 6 

Open the quick filter menu by clicking the arrow in the upper right corner and select Single Value List.

Step 7 

Drag the Customer Segment field from the Data window and drop it on Color.

As you select measure names in the quick filter, the view updates to show just that measure over time. For example, below Profit is selected to show Profit over time by Customer Segment.

 

Did this article resolve the issue?