Line chart with different lines per year

[Betty888]

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 ! 

[Ritaf1983 · Accepted solution]

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.

[Anonymous]

hello thank you for explaine how to do it
I have a question if anyone can help me 
i have a line chart 

I want to calculate the difference between each two points of the same date ?

[Betty888]

Hi @Ritaf1983 ,

Very many thanks for your reply ! it was really helpful !!!!

[amitchandak]

@Betty888 , You can have a year on legend

[Betty888]

Hi @amitchandak ,

Many thanks for your reply !