Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Best regards
Hi @Anonymous
what do you like to see? Something like this?
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?
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.
Best regards
Hi @Anonymous.
I have reviewed it and I have seen another link for the same reason:
thank you.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |