Creating a dual axis chart with same measure in Tableau

0 votes

I'm aware of how to create a dual-axis chart using two different measures for the Y-axis. 

What I want?

Create a dual-axis chart using the same measure but on two different range in the dual-axis? 

For example, I have a revenue column and, I want to create a dual-axis chart where one axis has revenue for the Year 2013, and the other with revenue for the Year 2014.

I want to create a line chart for the revenue Year 2013, and bar chart for the revenue Year 2014, on the same chart. See picture below is what I have done to have FY13 and FY14 values for each month and running monthly cumulative.

enter image description here

Now what I want to have the two FY13 bar charts to be line charts superimposed on their corresponding FY14 bar charts.

May 29, 2018 in Tableau by ghost
• 1,790 points

edited May 29, 2018 by ghost 8,775 views

1 answer to this question.

0 votes

Yes, this is possible.

  1. Drop the measure in the row shelf.
  2. Then grab the same measure with Control key pressed and drop it again on the row shelf.
  3. You will have two instance of the same measure on the row shelf.
  4. Right Click the second measure on the row shelf and click dual axis.
  5. Right click the axis on the worksheet and Edit axis to your choice.

Let me know if this solved your problem.

EDIT

Create 2 calculated feild:

  1. If [FY] = "FY13" then [Value] end

call it- 2013 and

  1. If [FY] = "FY14" then [Value] end

call it- 2014

Then just do as i have done in this image.

enter image description here

Ready to stand out in the world of data visualization? Explore our Tableau Certification Program and unlock a new realm of opportunities by validating your expertise in the industry's leading data visualization tool!

answered May 29, 2018 by Atul
• 10,240 points

Related Questions In Tableau

0 votes
1 answer
0 votes
1 answer

How to get multiple Sets of Measure Names with different Filters on a single sheet in Tableau?

The easiest solution to your query is: 1) ...READ MORE

answered Aug 23, 2018 in Tableau by Naruto
• 710 points
15,356 views
0 votes
1 answer

How to add a story with same sheet with different parameters and filters added in tableau?

Hi Riya, Follow these steps to add sheets/dashboard ...READ MORE

answered Mar 22, 2019 in Tableau by Cherukuri
• 33,030 points
3,596 views
0 votes
1 answer

how to change or edit the marks on a graph in a dual axis chart?

Hey Preethi, It's simple and easy, just ...READ MORE

answered May 21, 2019 in Tableau by anonymous
• 33,030 points
767 views
0 votes
1 answer

Create subset and overall value line chart

Hi Nithin, 1. First create a line chart ...READ MORE

answered Mar 13, 2019 in Tableau by Cherukuri
• 33,030 points
1,025 views
0 votes
1 answer

How to make label in center of dual axis chart?

Hi Banu, Follow below steps: 1. Create a dual ...READ MORE

answered Apr 2, 2019 in Tableau by Cherukuri
• 33,030 points
3,642 views
0 votes
1 answer

Stacked bar and line chart -Tableau

Hi,  Follow these steps to add a stacked ...READ MORE

answered Apr 3, 2019 in Tableau by Cherukuri
• 33,030 points
21,447 views
+1 vote
1 answer

Non-overlaid measures in dual axis chart within Tableau

The missing step is to specify the ...READ MORE

answered Jul 24, 2018 in Tableau by Atul
• 10,240 points
855 views
0 votes
1 answer

How to combine rows with same information in Tableau

@Ghost, Tableau has a function RANK_UNIQUE which you ...READ MORE

answered May 25, 2018 in Tableau by Atul
• 10,240 points
7,677 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP