Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Create a Line Chart with a Target Line

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. ...
  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous,

    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