You should add a workbook for someone to help you.
If you are trying to show actual and goal as bar in bar chart, u need to make 2 bar charts n then by using dual axis combine them. When you create dual axis, you will see only 1 bar chart. In order to visualize both charts you will have to decrease / increase the size of bars so that both the bars are visible distinctly. Also you might want to distinguish actual and goal measures by changing colours.
You can have a look at the attached pic.
Hope it helps you. Cheers mate!!!
Will this work with 16 measures. I've only seen this example with two measures. Do I need to group the measures or is there another way to separate the goals vs actual. As you can see in the example they are individual fields. I've update the attachment to show what happened when I followed the direction for the Bar in Bar chart. Thanks again for your assistance.
Crystal, this is going to turn out to be one of the situations where you need to reshape your data to get the result you want.
Your problem is that your data is spread out over a large number of columns. Remember the rule: Tableau prefers tall data vs. wide data. If you can, try to format the data as follows:
Contract Number <Measure Name> Percent Value
1 SBC Goal 10
1 SBC Actual 0
1 LBC Goal 90
1 LBC Actual 0
That way, you get one column with all your measure names, which you can then drop on the Columns shelf, and a column that contains only values that you can drop on the Rows shelf, then duplicate the values to get a dual-axis chart.
Can't guarantee that that is the exact table format you will need but it should be close.