I agree to that. However. Below are the predicted values. They also need to come in the same graph. Which is not happening.
Set Defects and Defect - What IF as dual axis similarly do it for Volume and Volume - What If
That way you are comparing actual and predicted values in same graph
1 of 1 people found this helpful
Drag "Measure Names" to the filter shelf.
Select your 4 measures.
Drag "Measure Values" to the rows shelf and remove the 4 individual measure pills.
Drag "Measure Names" to the colors shelf.
Now your 4 measures will all be on one viz, not even needing dual axis. You can make them bars, or lines or whatever else you want.
I tried it and this is how it shows up. It does not give me the option to change the graph for each metric.Attaching the book for the same.
I missed the requirement that you wanted two bars and two lines.
Looking at this.
If I had to do this, I would shape the data differently.
What you need is to be able to put out two distinct measures that each have different values when separated by an extra dimension.
(Attached is a quick stab at it. I actually have some excess stuff in there from a first attempt.)
What I ended up doing in the data source was to duplicate the rows so that I could have some dimension to separate the Volume from the Defect data, and duplicated it again so I can separate Actual from What-If on the viz. (I think the Volume/Defect separator isn't necessary in my final stab at this, but I didn't try taking it out...)
What I ended up with are two measures: Volume-Display and Defect-Display. they are on ROWS. In those calcs I made two different values. If Measure-type is "What If", I load in the What-If calc, otherwise I load in the actual data value.
I duplicated the data once more to create a second month just so that we can see the lines for Defects.
Right now the attached has not yet done Dual Axis on the two measures. I left it that way just so that you can see bars and lines. But you'll get lines on top of bars when you do dual axis.
What If 2.twbx 21.3 KB
Thanks Joe, could you share a sample file please.
The workbook is attached to my reply. In the lower corner of the reply you'll see a white box wit a paperclip icon. Click the file name in there.