Can't add secondary values in a line chart

[MXKCapgroup]

PowerBI desktop version 2.86 introduced a secondary Y axis in the line chart.  I am unable to drag a value in that chart.  I want to allow the user to select multiple values, some are total number of meetings and the other are percentages, so the scales are different.  If I drag a Value into the Value field, I can't drag something in the Secondary values field or vice versa.  Is this an issue with the data or a bug?

[themistoklis · Accepted solution]

@MXKCapgroup 

Remove UsageName from Legend section and try again

[themistoklis · Accepted solution]

@MXKCapgroup 

Remove UsageName from Legend section and try again

[MXKCapgroup]

That partially helps so thank you for that.  The other issue I have having now is that it aggregates the values instead of creating a single line for each selection.  For example, I'd want a line for each of the selection so there would be 4 in the case.  What is happening is the two items in red are being aggregated and the two items in green are aggregated, so I only have 2 lines.  

[Anonymous]

I tried this and it worked. I added two different metrics to a "Stacked Column Chart" on the Y-Axis - [LastYearTotals] & [CurrentYearTotals] of course with a [MonthName] on the X-Axis. I then change the chart from a "Stacked Column Chart" to a "Clustered Column Chart" and now I can see two Y-Axis.

[MXKCapgroup]

Here is a sample of my data...

[themistoklis · Accepted solution]

@MXKCapgroup 

I understand what you are trying to achieve but if legend cant actually help, in this case the alternative would be to create a separate measure for each value in UsageName field.

Based on the highlighted values (red and green - 4 in total) you will have to create 4 measures and add them to the visual. 2 in primary and 2 in secondary axis

[MXKCapgroup]

Thanks, I actually will need more measures but let me try that.  I'll accept as solution if I can get it work.