KNOWLEDGE BASE

Creating Dynamic Titles Based on Filters


Published: 18 Apr 2013
Last Modified Date: 23 May 2017

Question

How to create dynamic titles that change based on filter selections.

Environment

Tableau Desktop

Answer

  1. In Tableau Desktop, create a new worksheet named "Title."
  2. Drag the field you want to change dynamically to Detail. In the example workbook, Product Category is used.
  3. Change the mark type to Polygon.
  4. Select Worksheet > Show Title.
  5. Right-click the Title shelf and select Edit Title.
  6. In the Edit Title dialog box, delete <Sheet Name>, select Insert > Product Category, and then click OK.
  7. Drag Product Category to Filters and click OK.
  8. Right-click Product Category on Filters and select Show Filter.
  9. Create a dashboard and add the Title sheet to the dashboard.
  10. Resize the worksheet on the dashboard as needed to display the title.

To view these steps in action, see the video below:

Additional Information

You can also format the title text by double-clicking the Title sheet on the dashboard. Or, you can add a dimension (or other field) from which the title is derived to Columns, and hide everything else on the dashboard as this will prevent "All" from displaying when all values of dimension filter are enabled to include in view. 

Adding text in the title can also help with the type of selectio. For example, using "Select A Product Category  <Product Category> selected" as text would display titles similar as the following examples:
  • All product categories are selected: 
Select A Product Category
All selected
  • No product category selected: 
Select A Product Category
None selected
  • One or more product categories are selected: 
Select A Product Category
Furniture & Technology selected

 
Did this article resolve the issue?