How to Transpose Columns to a lot of records in Power Query - Or another way

[eghusseinr]

Hello Collogues.

I am asking for some ideas, below in one on interactive report i am working on it, Data source is a SharePoint list, as you see in Pic.1. which has many columns. the problem that I need to make the visual in Pic.2 but it always gives me a continues line "Blue" . How can i make it like the Brown line in below visual?

PS. i make the brown line on excel using Xlookup function, Pic.3 for refrence.

Thanks

123

[christinepayton]

It's hard to tell without more info about what you're doing now, but you want to select JUST the columns you want to unpivot (so the quarters), unpivot only those, then drop that resulting column with the quarter labels into the axis. You will very likely run into an issue with sorting the axis, because the quarters are text, not dates, so you will want to add a conditional column or use a date table to specify an alternate sort order for the quarters.