Tableau: Hiding values in a chart with two dual axis

Question

I have a chart with dual x-axis and dual y-axis. My table currently looks like this: Since there is 2 dual axis in my chart it is showing

• Blue x Depth
• Blue x Shapes
• Orange x Depth
• Orange x Shapes

I want to hide the Orange x Shapes portion of my chart. Is there a way to do this? Possibly filter it out from the view? I tried to right click the legend to hide or exclude "Square, Orange" and "Triangle, Orange" but the option isn't available.

Edit: Here is a workbook with dummy data dummy workbook

Thank you!

Answer 1

I posted the same question in Tableau Community and a solution with screenshots has been posted: Solution

The basic steps to solve this is to

1. In the Data Source tab, Union the data with itself which creates a column called [Table Name].
2. Create Two Calculated columns:
3. Orange 2 -> if [Table Name] = "Dummy Data" then [Orange]
4. Shape 2 -> if [Table Name] = "Dummy Data1" then [Shapes]
5. In the sheet/chart, replace Orange with Orange 2 and Shape with Shape 2
6. In the Depth mark, add Table Name to Details