cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
New Member

Line Chart - Multiple values with legend

Good Morning,

i need a line chart that shows 3 different fields (as values) and include a legend.

Imagine this example:

ITEMVALUE 1VALUE 2VALUE 3
A368
A554
A684
B533
B362
B272
C485
C636
C728
D858
D827
D346


If I add more than one of the values, I can not include item as a legend. Is there any way to do it?

Thank you,

Jaime

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Anonymous
Not applicable

Re: Line Chart - Multiple values with legend

Hi @jaimejim ,

 

this is actual not possible.

This is still an idea to add two or more values and a legend in a line chart.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9679077-two-values-and-legend-on-...

 

Best regards

View solution in original post

5 REPLIES 5
Highlighted
Anonymous
Not applicable

Re: Line Chart - Multiple values with legend

Hi @jaimejim 

 

what do you like to see? Something like this?

Line Chart.png

Highlighted
New Member

Re: Line Chart - Multiple values with legend

Hi @Anonymous , thanks for answering.

 

I've done a much better example where you see what the problem is:

 

ForecasterForecaster productionReal productionProduction offeredDATE
A36620/01/2018
A55621/01/2018
A68722/01/2018
B56620/01/2018
B35621/01/2018
B28722/01/2018
C46620/01/2018
C65621/01/2018
C78722/01/2018
D86620/01/2018
D85621/01/2018
D38722/01/2018

 

This is my table and i want to see in a line chart 6 lines (one for each forecaster, other of "Real production" and the last one of "Production offered.

 

Now, i only see 2 ways to do this line chart:

 

1- Value: forecaster production and legend: forecaster (4 lines)

2- Values: forecaster production, real production and production offered (3 lines)

 

I need to show all, but i dont know how i can do it....

Any help?

 

 

 

 

 

Highlighted
Anonymous
Not applicable

Re: Line Chart - Multiple values with legend

Hi @jaimejim ,

 

this is actual not possible.

This is still an idea to add two or more values and a legend in a line chart.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/9679077-two-values-and-legend-on-...

 

Best regards

View solution in original post

Highlighted
New Member

Re: Line Chart - Multiple values with legend

Hi @Anonymous.

 

I have reviewed it and I have seen another link for the same reason:

 

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/12407130-line-chart-with-multiple-values-fields-and-legends

 

thank you.

Highlighted
Helper II
Helper II

Re: Line Chart - Multiple values with legend

Guys have a look at this 

https://community.powerbi.com/t5/Desktop/Line-chart/m-p/706349#M341006

 

As I managed with the help of @v-juanli-msft 

 

 

 

 

 

 

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.

Top Solution Authors