2 Measures on the same axis in a scatter chart

[RobElvers]

Hello everyone,

I have a question regarding data series visualization in a scatter chart.

First here is how the chart should look like. I have just mapped the margin ytd data to the y axis and the revenue share to the x axis. The subjects of the analysis are the different article groups (mapped to the category field). For each article groups there are two data points, one for the fiscal year 19 and the other for the fiscal year 20. The arrows between these 2 points are possible because i use the bubble/scatter chart - xViz. 

So far so good. However, now i want to substitute the margin ytd data with two different measures, namely the margin mtd and the margin ytd of last month. I managed to create these measures and they are correct. But I just can't put these two measures in this chart for the y-axis, so that they both show up and so that i can link them together with arrows. As far as i understand the shown chart works since it is only one data series on the y axis and the legend field year can differentiate this data. But how can i achieve the same for my 2 new measures? 

Thanks a lot for any help 🙂 

[mahoneypat · Accepted solution]

Although there is some learning curve, this would be doable with the Charticulator visual.  It is well worth learning how to use.

(9) Season 1 - Charticulator - YouTube

Pat

[RobElvers]

Thanks Pat

I watched the first vid and tried it out myself. However, after i downloaded the charticulator app i just couldn't find it in the visuals box. When I was downloading it again, it said that it was installed already. Is that a bug? 

[mahoneypat]

It should be the bottom one in this picture.

Pat

[RobElvers]

Wow. Thanks for the fast reply.

Yes, it should be there but unfortunately it isn't. 

It just doesn't show up at all