Forum Discussion
Need help for creating 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.
You need to unpivot the month columns in Power Query. Then setting up the graph os straightforward .
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.
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.