If you click on show me , you can see one chart type right below the pie chart. By clicking it you can visualize multiple measures in single view. Hope this help and do let me know whether it was helpful or not. Thank you.
Would your viz work as a dual-axis graph?
The first axis would be a line-chart, spread over both 2016 and 2017. The year controls the color.
The second axis would be the bar-chart-- also spread over 2016 and 2017. Use the Year as a dimension to control the color (or just write a little calc to come up with values).
I'm uncertain what you're showing in your line graph, but I was able to get results using this method:
Sorry, this approach will not work for me. In the example above there are two measures, and I need to show four. Just can't understand why I can add a third measure as a line, but it does not work when I try to add a 4th measure (defaults to bar).
Please find the my workaround.
1. I have kept two measures as row and made it dual axis.
2. 3rd and 4th kept as details and added them as reference line.
3. Edited reference label as symbol (one as round and other as triangle)
4. Scope for reference set as "per cell".
(or) go throgh the attachment.
Hope it will be helpful to you.
Dual Axis 4th Measure.twbx 31.9 KB
Thank you for the interesting example. However this is not exactly what I need. I apologize if I am not explaining it correctly.
I need to know how I can add a 4th measure and have it on a separate shelf on the marks card. Similar to "Measure C" shown below. I know it matters how you drag measures onto the axis, but I've tried several different ways and cannot get it to work.
So it sounds like you have 4 unique measures:
Bar A (2016)
Bar B (2017)
Line A (2016)
Line B (2017)
If this is the case, and there is no overlap between the measures, can you make two calculations based on YEAR, and create a dual-axis graph off of them?
If [Year] = 2016 then [Bar A Measure]
Else if [Year] = 2017 then [Bar B Measure]
The Line Value calc would be similar.