cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

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.

josstan_0-1603140763032.png

josstan_1-1603140776519.png

Thanks in advanced for any help

 

1 ACCEPTED SOLUTION

Accepted Solutions
Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

3 REPLIES 3
Super User IV
Super User IV

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



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

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.

Community Support
Community Support

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors