Forum Discussion
Need help for creating Line Graph
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
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 1If 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.
3 Replies
PaulDBrownCommunity Champion
You need to unpivot the month columns in Power Query. Then setting up the graph os straightforward .
- PaulDBrown
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 1If 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.