Forum Discussion
Create a Table (as a measure?)
Unpivotting all the Period columns is the right way to do it. You then have the numeric values in one column so you can plot them.
You maybe need to manipulate the Attribute column so that you can get the x-axis values to order correctly. So probably create a calculated column or Power Query column to make a sortable value , for example
Period 03 2023 -> 2023/03 (fairly straightforward to do).
If you want a Year column, you can extract that too.
Bear in mind these are text values at the moment.
Unpivotting all the Period columns is the right way to do it. You then have the numeric values in one column so you can plot them.
You maybe need to manipulate the Attribute column so that you can get the x-axis values to order correctly. So probably create a calculated column or Power Query column to make a sortable value , for example
Period 03 2023 -> 2023/03 (fairly straightforward to do).
If you want a Year column, you can extract that too.
Bear in mind these are text values at the moment.