KNOWLEDGE BASE

How to display the axis label for each data


Published: 07 Apr 2023
Last Modified Date: 11 Apr 2023

Issue

How to display axis for each data.

The view below shows Sales data for each Category.
<Current Behavior>
User-added image
<Desired Behavior>
User-added image

Environment

  • Tableau Desktop

Resolution

Create a sheet for each data and apply the sheet selector and add each on the dashboard.

1. Connect to Sample Superstore from Tableau Desktop.
2. Drag [Order Date] to Columns and [Sales] to Rows.
3. Drag [Category] to Color on Marks.
4. Drag []Category to Filter Pane -> Check in only 'Furniture'.
User-added image
5. Create a new parameter as following.
User-added image
6. Right click on [Show/Hide Furniture] -> Show Parameter
7. Crate a new calculated field as following.
     Name : Furniture Filter
     Calculation : [Show/Hide Furniture]
8. Drag [Furniture Filter] to Filter Pane -> Check in 'Custom value list' -> Enter '1' to search bar -> Press Enter key -> Check in '1'
User-added image
9. Right click on Sales Axis -> Edit Axis -> Change the Title to 'Furniture'.
User-added image

10. Crate a new sheet -> Replace the category with [Office Supplies] and perform steps 2 ~ 9.
11. Crate a new sheet -> Replace the category with [Technology] and perform steps 2 ~ 9.

12. Create a new dashboard 
13. Drag 'Horizontal' object at the top and bottom of the dashboard as shown below.
User-added image
14. As following image, place each sheets in the "Horizontal container" below.
User-added image
15. Delete Color Legend from dashboard.
User-added image
16. Adjust containers height.
17. Click on Furniture sheet on dashboard -> Delta mark -> Title
//Title is hidden.
User-added image
18. Apply step 17 to the other 2 sheets.

 

Cause

This feature is not built in Tableau Desktop yet.
Did this article resolve the issue?