How can you pull a third measure into a dual axis bar in bar chart in Tableau Desktop?

Category:
Question ID: 109814
0
0

Thanks again for all of your help before. When attempting to create this stacked bar chart I am able to bring in two of the years worth of data but when attempting to bring in a 3rd, 4th, 5th, etc. after, it doesn’t end up working the way I want. I just want to continue to add other bars inside these two but I end up with the two screenshots attached. Any info would be appreciated.

 

Attachments:
Marked as spam
Posted by (Questions: 2, Answers: 1)
Asked on August 26, 2020 4:07 pm
7 views
Thank you! I've learned so much. I will surely be in touch as I encounter issues in the future.
( at August 28, 2020 11:31 am)
Answers (1)
1
Private answer

Hello Chester! You are on the right track. Since with a Dual Axis chart we only have two axes, When you pull in a third measure you end up with the charts you posted pictures of. Honestly when only using two measures, the method that you used prior to bringing in the third measure is the best option. However, when you need to bring in three or more measures you have to use a different trick.

  • You will need to first create a combined axis chart with all of the measures that you want in the view by dragging the second, third, fourth, etc. measure to the same axis that the first measure gave you.
  • Once you have all of your measures on the same axis you will need to remove Measure Names from the Rows shelf to create a Stacked Bar chart.
  • The trick here is to go up to the Analysis menu up at the top and select Stack Marks and then set it to Off.
  • Finally, because you want each measure to have its own size you will need to put a copy of Measure Names on Size on the Marks card so that each measure has its own size.

Please give it a shot and let me know how it works! Good luck!

Attachments:
Marked as spam
Posted by (Questions: 1, Answers: 9)
Answered on August 27, 2020 3:19 pm