In this article we will learn what is dynamic axis title and how to display dynamic axis title in Tableau charts.
What is Dynamic Axis Title ?
Dynamic Axis title is a new feature in Tableau 2023. It is used to update/display the chart axis title based on the parameter selection or a single-value field.
For a field to be used as Dynamic Axis Title, it should be:
- A single-valued and a fixed LOD Calculation
- A parameter
- A constant calculated field
- A top 1 set
How to implement Dynamic Axis Title
To explain how to display dynamic axis title, I will reference the blog How to dynamically generate a chart based on measure selection.
The visualization created to dynamically generate the chart based on measure selection is displayed below:
Notice that the Y-axis title is currently shown as “Calc_Measure_Name”, representing the name of the calculation using the parameter. It should instead display the selected parameter value, which in this case is “Quantity”.
To implement a dynamic axis title, right-click on the Y-axis (Calc_Measure_Name) and choose Edit Axis.
In the “Edit Axis” dialog box, scroll down and, under Axis Titles, select the Parameter name from the dropdown menu.
Now, the title on the Y-axis will display the value selected in the parameter.
To discover additional tips and master Tableau, explore the book Dashboarding with Tableau.
About the Author
Chandraish Sinha is passionate about data and analytics. He is an accomplished author, having published multiple computer-related technical books. For more insights explore his Amazon Author profile .
With over 20 years of experience, he has worked with various BI and reporting applications, such as, Actuate, Business Objects, IBM Cognos, Tableau and QlikView. His exepertise spans across different domains such as Pharmaceutical, Healthcare, Telecom, Financial and Retail.
Chandraish Sinha is also the founder of Ohio Computer Academy, a leading IT education organization.
Books authored by Chandraish Sinha
- Excel Basics to Advanced
- Dashboarding with Tableau
- Mastering Power BI
- Tableau Unlimited: Basics to Advanced
- Implementing Tableau Server: A Guide to implementing Tableau Server
- Tableau 10 for Beginners
- Tableau Dashboards
- Tableau Questions & Answers
- QlikView Essentials
- QlikView Questions and Answers
- How to be a Successful IT Professional in the USA