KNOWLEDGE BASE

Creating Dynamic Titles Based on Filters


Published: 18 Apr 2013
Last Modified Date: 08 Feb 2017

Question

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

Environment

Tableau Desktop 8.0 and later versions

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.
Did this article resolve the issue?