Need help for creating Line Graph

[Anonymous]

Need help to create a line graph with months in the x axis for the given below table. Project number is not necessary to be displayed or even used in graph. 

I want to show the performance on monthly bases.

For example - jan = "sum of all the sales in Jan" is one value

Project	Jan	Feb	Mar	April
1	22	22	22	22
2	34	34	34	34
3	33	33	33	33
4	55	55	55	55
5	66	66	66	66
6	77	77	77	77

Example of line graph 

[PaulDBrown]

You need to unpivot the month columns in Power Query. Then setting up the graph os straightforward .

[Anonymous]

Hi i used the unpivot in power query. 

When i tried the line chart, im getting the below output. 

Please advise on how to have the x axis values from P01 - P07 

The x axis in not in ascending order. I did sort the coloumn in table but still the graph is shown like this.

[PaulDBrown · Accepted solution]

In Power Query, you can try the following (you need a column for sorting purposes):

1) If the periods are sorted properly, add an index column

2 If the periods are not sorted chronologically, add a conditional column along the lines of:
If the period table = Sales P01 (actual) then 1

If the period table = Sales P02 (actual) then 2

....

Once the table is loaded, go into the table view, select the period table and in the ribbon, select "Sort by column" and select the order column.