It might be possible to do what you're trying to achieve by using gantt instead of bar charts. In the example below, the line doesn't match up, but because proficiency performance level is a specific value in your chart (I'm assuming) it should match up and you can add a reference line with that value as a constant. I sized by sales, but you might have to play around with your case.
If you're having trouble figuring it out, can you attach a workbook with markup data?
Hope this helps!
Thank you for the response. I still couldn't figure out how get it down. A
reference line will not align across filters. Can you kindly dummy it to
me. Attached is a sample workbook. What I want is to align the green bars
which represent proficient and advance above the line and the orange and
red underneath the line in such a way that it will work when using filter.
On Thu, Oct 13, 2016 at 8:40 AM, Lisa Li <firstname.lastname@example.org>
The data architecture is different from what I expected. My solution does not work in your case since you are charting the number of students instead of the score like I assumed. I don't believe this will be possible with the current data architecture and don't really know what to change it to.
Sorry I can't be of more help.
1 of 1 people found this helpful
In order to build the viz you're after I had to pivot your data set (I connected to the same data set again and used Tableau's pivot function on the data source window).
Once that was done, it was pretty straight forward putting all three metrics on a single viz, and zeroing the data based on performance score was a single calculated field: