Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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.
Proud to be a Super User!
Paul on Linkedin.
You need to unpivot the month columns in Power Query. Then setting up the graph os straightforward .
Proud to be a Super User!
Paul on Linkedin.
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 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.
Proud to be a Super User!
Paul on Linkedin.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
53 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |