Create a Line Chart with a Target Line

[josstan]

I currently have a Line and Cluster Column Chart with a Target line for my line values.

How can I convert this to Line chart. Would line to see values in line form compared to my target line.

Thanks in advanced for any help

[Anonymous · Accepted solution]

Hi @josstan,

Nope, current power bi does not support to use legend fields and multiple values field at the same time. (Analysis panel excited triage line, but it is static values. if you want to make it dynamic, you need to add your value field to the visual fields, then you can choose it in the options)
I think you may need to modify your table structure to unpivot these fields to attribute and value, then you can use attribute on legend and value in the Value field to achieve your requirement.

Unpivot columns (Power Query) 
Regards,

Xiaoxin Sheng

[amitchandak]

@josstan , not very clear. You can have diff measure and plot that on line?

[josstan]

These values are column values. Id like the Earn Hours Sum column to appear as line. Cant figure out how to put two columns in for values. Is that possible.