Tableau 2023 feature Updating Dynamic Axis Titles Automatically
Check my website www.dancesingwithdata.com
Published: 29 Apr 2013
Last modified date: 14 Mar 2023
Issue
When using a parameter to select an axis, the axis title does not update automatically prior to 2023.1.
Environment
Tableau Desktop
Resolution
1. Upgrade to version 2023.1 or later. New to 2023.1, is the dynamic axis title option. The Edit Axis dialog now has the option for Automatic as well as Fixed. Pick any parameter or single-value field to use the Automatic Axis option.
User-added image
2. For versions prior to 2023.1, use calculated fields to define the axis titles as demonstrated below.
Creating the Calculated Fields
Create a calculated field for one axis.
Structure the formula of the calculated field as follows:
CASE [AXIS SELECTOR PARAMETER]
WHEN "Parameter option 1" THEN "Parameter option 1"
WHEN "Parameter option 2" THEN "Parameter option 2"
WHEN "Parameter option 3" THEN "Parameter option 3"
WHEN "Parameter option 4" THEN "Parameter option 4"
WHEN "Parameter option 5" THEN "Parameter option 5"
ELSE NULL
END
Note: the quotation marks may need to change from double (") to single (') in order to function
Add a title to the new calculated field, and click OK.
Repeat steps 1 - 3 for the second axis.
Removing Existing Axis Titles
Right-click on the axis in the visualization and select Edit Axis....
Delete any text in the Title box in the bottom right, and click OK.
Repeat steps 1 and 2 for the second axis.
Adding the Calculated Fields to the Visualization
Drag each calculated field f to their respective row shelf or column shelf.
Right-click on the column field label (it will appear as the title of the calculated field in the visualization), and select Hide Field Labels for Columns.
Right-click on the row field label (it will appear as the title of the calculated field in the visualization), and select Hide Field Labels for Rows.
Right-click the Y-axis title, and select Rotate Label if desired.
Cause
Feature released with 2023.1.