Forum Discussion
Solved
Equivalent behavior to Switch Rows-Columns in Excel
Below is an example of a table of data which I've been asked to put into a visual: Month_Year AggPct1 AggPct2 AggPct3 AggPct4 AggPct5 AggPct6 Jan-21 24.06 29.8 32.86 34.81 36.11 ...
I think if you went into power query.
Selected your Month_Year column and then on the transform tab clicked unpivot other columns. You should then find it easier to build the graph you want.
I think if you went into power query.
Selected your Month_Year column and then on the transform tab clicked unpivot other columns. You should then find it easier to build the graph you want.