Last Modified Date: 08 Jul 2022
Environment
Tableau DesktopResolution
As an possible workaround, using dual-axis and a calculation field could achieve similar result. Please find the attached sample workbook for more details.(built in 2019.3.0)Step 1: Create two calculated fields
- Select Analysis > Create calculated field
- Name the calculated field "Container"
- Enter the following formula and click OK:
AVG(0)
- Select Analysis > Create calculated field
- Name the calculated field "Color2017"
- Enter the following formula and click OK:
IF DATEPART('year', [Order Date])=2017 THEN "2017" ELSE "other" END
Step 2: Build the View
- Drag Order Date to Columns and Discount to Rows
- Drag Measure Names to Color
- Drag the new calculated field [Container] to Rows, next to SUM(Discount)
- Right-click Container and select Dual Axis
- On the right axis named Container, right-click and select Synchronize Axis
- On Columns, right-click Year(Order Date) and select deselect Show Header
- In the marks cards, select the Container mark and change the visualisation type to Text
Step 3 - Fix the axis location
- In this example, we want to lower the text underneath the Bar Chart, therefore we need to lower the value of the [Container] calculated field to AVG(-10)
- Remove Measure names from Color.
- Drag the new calculated field [Color2017] to Color.
- Drag Order Date to Text.
- Edit the color palette of the dates as desired.
- (Optional) Hide unnecessary frame border.
Cause
The ability to customize the formatting text on axis is not currently built into the product. Add your vote to the following Community idea: Improve Uniformity on Edit Axis Menu.Additional Information
To view the above steps in action, see the video below.Note: the video has no sound.
Thank you for providing your feedback on the effectiveness of the article.
Open new Case
Continue Searching
Knowledge Base
Community
Product Help
Training and Tutorials