How to stack one column above of the other

[Mp3Robbo]

Hi all

I'm wondering if there is a way to stack one column above the other in Power BI?

I hope the below graphic explains what I am trying to do. As can be seen the created column has twice as many rows as the columns from the original table.

Please let me know if I haven't explained this well enough.

Thanks, Rob

[v-chuncz-msft]

@Mp3Robbo,

You may use Stacked column chart from the Visualizations pane.

[Mp3Robbo]

@v-chuncz-msft

I guess I didn't explain well enough, sorry about that, perhaps the colours made it a bit confusing.

What I'm trying to do is what I have drawn below (using DAX or whatever).

Thanks, Rob

[v-chuncz-msft · Accepted solution]

@Mp3Robbo,

You may select Unpivot Columns in the Query Editor or use UNION Function in DAX.