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.
Community ChampionThere seem to be a couple of challenges here
1. The syntax that has been written doesn't work but, even if it did, it doesn't help you plot the data
2. The desire to plot your data in a useful way.
--
I suggest ignoring (1) and concentrating on (2).
If you provide a small sample of data and show your desired result, someone will help.