Improving Your Dynamic or Repeated Text in Tableau

Data

Improving Your Dynamic or Repeated Text in Tableau

One of the many helpful features in Tableau is the ability to create dynamic text boxes that update depending on user selection or other events on the dashboard. It’s a common practice to use parameters in text boxes. That’s why I would like to offer a few tips and tricks in this post to enhance your dashboards and reduce the effort involved when updating text boxes.

Dynamic Text Boxes Using Parameters

Text boxes are often used in Tableau to display varied information based on a parameter. For example, we could have a parameter determine how a table is sorted and a text box explaining that sort. When a user changes the value of the parameter, this selection is also reflected in the text box. This is accomplished by using the Insert option in the top-right corner of the text box editor and selecting the parameter:

Improving Dynamic Text in Tableau

The Problem with Dynamic Text Boxes

There are two key issues with using dynamic text boxes:

  1. When using text boxes with the same text on a series of dashboards, each text box on each dashboard must be updated whenever a change is required. As the number of dashboards increase, this can create a significant risk of a text box being accidentally skipped. It will take more time than necessary to update the dashboard.
  2. The dynamic nature of the text is limited to parameters.

Solving the Problem with Sheet Titles

Dynamic text boxes can be powerful; however, you can accomplish far more by using dynamic sheet titles instead of text boxes. Here are two ways you can do this:

  1. Use a blank sheet instead of a text box. The sheet can be dragged into as many dashboards as desired. You can also use parameters exactly like you would in the text box method. When using this method, updating the workbook requires updating a single sheet title instead of updating every occurrence of the text box:

Improving Dynamic Text in Tableau

  1. Titles of sheets can make use of any field in the data source in addition to parameter entries. For example, we could include the total Sales/Profit in our title:

Improving Dynamic Text in Tableau

Improving Dynamic Text in Tableau

Using Calculated Fields

By using calculated fields, the true potential for sheet titles can be realised. In the following example, we have allowed filtering by segment and we built a dynamic text box to reflect it. This includes two calculated fields that make minor adjustments to the text. The first determines whether the word “the” needs to be present in the text, and the second determines whether the word “segment” should be plural:

Improving Dynamic Text in Tableau

Improving Dynamic Text in Tableau

To see an example of this in action, check out my dashboard on Tableau Public below and reach out to us if you have any questions. Thanks for reading!

More About the Author

Chris Hastie

Data Architect
A Definitive Guide to Creating Python UDTFs Directly within the Snowflake User Interface Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake ...
An Introduction to Python UDTFs in Snowflake Snowpark for Python is the name for the new Python functionality integration that Snowflake has recently developed. At the Snowflake ...

See more from this author →

Subscribe to our newsletter

  • I understand that InterWorks will use the data provided for the purpose of communication and the administration my request. InterWorks will never disclose or sell any personal data except where required to do so by law. Finally, I understand that future communications related topics and events may be sent from InterWorks, but I can opt-out at any time.
  • This field is for validation purposes and should be left unchanged.

InterWorks uses cookies to allow us to better understand how the site is used. By continuing to use this site, you consent to this policy. Review Policy OK

×

Interworks GmbH
Ratinger Straße 9
40213 Düsseldorf
Germany
Geschäftsführer: Mel Stephenson

Kontaktaufnahme: markus@interworks.eu
Telefon: +49 (0)211 5408 5301

Amtsgericht Düsseldorf HRB 79752
UstldNr: DE 313 353 072