Line chart with 2 variables on the Y-axis and a legend, how to do it?

[luizenrique]

I have a set of data, and I would like to know how I can place 2 variables on the Y-axis since, when I add a legend (to differentiate the lines for different years), it does not allow me to add another field to the Y or secondary Y-axis.

[Anonymous · Accepted solution]

HI @luizenrique,

Current power bi desktop does not support use legend and multiple value fields at the same time.
For your scenario, pehrhaps you can remove the legend field to use multiple value fields or try to write a measure formula based on current legend values to redirect to different expressions.

Regards,

Xiaoxin Sheng

[parry2k]

@luizenrique you can have a  column in legend well or multiple measures, but you cannot have both at the same time.