KNOWLEDGE BASE

How to Change or Rename the Dimension Header in a View Without Changing the Dimension Name in Data Source


Published: 11 Jan 2022
Last Modified Date: 13 Jan 2022

Question

How to change the dimension header in crosstab without actually changing the Dimension Name in the data source?


User-added image

Environment

  • Tableau Desktop

Answer

The ability to only change the dimension header in the view is not currently built into Tableau Desktop. Instead, consider the workaround which achieves a similar functionality.

Follow the steps below:

1. Double-click the dimension added to the [Rows/Columns] shelf.


User-added image

2. Add "//Dimension Name" at the beginning.


User-added image

3. Press "Shift + Enter" to add a new line character.


User-added image
 

Finally, the dimension header can be changed like in the below image.


User-added image
* The dimension in the [Rows/Columns] shelf has two lines like below and it will show the first line as header and show the dimension in the second line.
---------------------
//Dimension Name
[Category]
---------------------

Please check the attached workbook for details.

Additional Information

For more  information, refer to this related Youtube Video.
Did this article resolve the issue?