Forum Discussion
Solved
Pivot/Unpivot or Transpose Solution to plot line chart
I have the following structure in a table: Name Metric July 2025 August 2025 Sept 2025 Oct 2025 Nov 2025 Dec 2025 Jan 2026 Alpha Volume 0.85304 0.145932 0.558814 0.260746 0.927...
Try this solution.
1. In Power Query, select all Month Year columns and unpivot.
Rename columns as desired.
2. Create measure:
Metric Value = SUM ( 'Table'[Value] )3. Create visuals:
Try this solution.
1. In Power Query, select all Month Year columns and unpivot.
Rename columns as desired.
2. Create measure:
Metric Value = SUM ( 'Table'[Value] )
3. Create visuals: