Different columns in a line chart

[wooand]

I have several columns of data that I would like to show in a line chart with each of T-3, T-2, etc along the X, and BP cost up the Y axis.

Whilst I can create a clustered column visual, I can't produce a line chart that orders the data from each column so that the line produced would reflect the BP costs at each value of 'T' along the X axis.

Any help most gratefully received.

[v-chuncz-msft]

@wooand,

You may try to select Unpivot Columns in Query Editor first.

https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415

[wooand]

Thanks, that's a great help, but now I am getting this:

Aside from being in the wrong order, the X axis is now correct, but the values, which should be a number for each point will only allow 'count of'.  What am I doing wrong now pls?