Forum Discussion
line chart help
Hi, i am wondering if i could make a line ( trend) chart.
The x-axis would be 2024-Feb, 2024-March, 2024-Apr.. etc. till 2025-Jan
The Y-axis would be data associcated with 2024-Feb, 2024-March. etc.
so, for example: Y-axis would be: 50, 60, 70, 50, 80, 90.. etc total 12 data points, while x-is 2024-Feb, 2024-March, etc.
I can move the 12 data points to Y axis, but it would be straight vertical line. How can i make a trend line to show the trend from 2024 Feb to 2025 Jan? Both X and Y axis info are from same field. Thanksπ
BI desk top -data screen shot
Learned from another post that i could use Unpivot Columns function in Power Query Editor ..thanks
https://community.fabric.microsoft.com/t5/Desktop/Line-Chart-Help/m-p/4245427
2 Replies
- QQ395New Member
Learned from another post that i could use Unpivot Columns function in Power Query Editor ..thanks
https://community.fabric.microsoft.com/t5/Desktop/Line-Chart-Help/m-p/4245427
- SamanthaPuaXYHelper II
Hi QQ395,
You would need to do a pivot on your table such that your end output should look like
| Address | Branch | City | Date | Value |
Only this way you'll be able to plot a nice x-y line chart.Let me know if you require further help. π