Forum Discussion
Line chart with different lines per year
Dear all,
I have a dataset that looks as below :
| Company | Year | Sales |
| 1 | 2018 | 60 |
| 1 | 2019 | 30 |
| 1 | 2020 | 35 |
| 2 | 2018 | 25 |
| 2 | 2019 | 63 |
| 2 | 2020 | 35 |
| 3 | 2018 | 98 |
| 3 | 2019 | 96 |
| 3 | 2020 | 22 |
| 4 | 2018 | 65 |
| 4 | 2019 | 89 |
| 4 | 2020 | 75 |
| 5 | 2018 | 49 |
| 5 | 2019 | 12 |
| 5 | 2020 | 32 |
and I want to create a graph as I tried to draw below 🙂
1 line per year and X axis = Company name / Y axis = sales (my response variable).
Can you please suggest any way to do this in Power Bi please 🙏
Thank you in advance for your help !
Hi Betty888
In order to get to the graph you drew, follow these steps:
1. Choose line chart
2. Put your parametrs like on pict :3. Set up a series labels
It is important to note that such a logical comparison is problematic.
A trend line shows the evolution of an index over time.
It is recommended to make an X-axis as a time axis in order to compare long-term trends between companies.
For each company, there is a representative line.
As you have several lines that collide, it is better to split it into smaller graphs so you don't create cognitive load
Using "small multiples"
As shown in the picture (with setup a right format and design)Link to sampke file with both options here
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Betty888
In order to get to the graph you drew, follow these steps:
1. Choose line chart
2. Put your parametrs like on pict :3. Set up a series labels
It is important to note that such a logical comparison is problematic.
A trend line shows the evolution of an index over time.
It is recommended to make an X-axis as a time axis in order to compare long-term trends between companies.
For each company, there is a representative line.
As you have several lines that collide, it is better to split it into smaller graphs so you don't create cognitive load
Using "small multiples"
As shown in the picture (with setup a right format and design)Link to sampke file with both options here
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi amitchandak ,
Many thanks for your reply !
