Line Chart - Multiple values with legend

[Anonymous]

Good Morning,

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

Imagine this example:

ITEM	VALUE 1	VALUE 2	VALUE 3
A	3	6	8
A	5	5	4
A	6	8	4
B	5	3	3
B	3	6	2
B	2	7	2
C	4	8	5
C	6	3	6
C	7	2	8
D	8	5	8
D	8	2	7
D	3	4	6

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

[Anonymous]

Hi @Anonymous 

what do you like to see? Something like this?

[Anonymous]

Hi @Anonymous , thanks for answering.

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

Forecaster	Forecaster production	Real production	Production offered	DATE
A	3	6	6	20/01/2018
A	5	5	6	21/01/2018
A	6	8	7	22/01/2018
B	5	6	6	20/01/2018
B	3	5	6	21/01/2018
B	2	8	7	22/01/2018
C	4	6	6	20/01/2018
C	6	5	6	21/01/2018
C	7	8	7	22/01/2018
D	8	6	6	20/01/2018
D	8	5	6	21/01/2018
D	3	8	7	22/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?

[Anonymous · Accepted solution]

Hi @Anonymous ,

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-line-chart

Best regards

[Anonymous]

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.

[brinky]

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