cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
marami21
Frequent Visitor

Stack columns one after the other

I have something like this:

10.PNG

And I need to change it to something like this.11.PNG

 

 

 

 

 

 

 

I know this can be done with unpivoting but I've tried several times and I have not been able to achive it. 

1 ACCEPTED SOLUTION
Mariusz
Community Champion
Community Champion

Hi @marami21 

 

Please see the attached solution, its three steps using UI only.

image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

View solution in original post

4 REPLIES 4
Mariusz
Community Champion
Community Champion

Hi @marami21 

 

Please see the attached solution, its three steps using UI only.

image.png

 

Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

marami21
Frequent Visitor

Can you please explain to me what does split column by character transition do?

Mariusz
Community Champion
Community Champion

Hi @marami21 

 

If you asking how it works, its a function that iterates each "Attrbute" field, converts it into a list, scans this list for numbers 0 to 9 and splits the column if the number is found.

 

The below screenshot shows how to create this step.

image.png

 
Best Regards,
Mariusz

If this post helps, then please consider Accepting it as the solution.

Please feel free to connect with me.
Mariusz Repczynski

 

jdbuchanan71
Super User
Super User

Hello @marami21 

I think what you need to do is split your original table into blocks then stack them.  In the attached file there are 5 queries.

The first one just pulls in the data

The next three reference the first one (no reason to load the data again) an pull just the set of columns for that block then renames the columns

The final query stacks together the previous three

All but the final query are set to not load to the model since we only care about the final result.

DisableLoad.jpg

 

StackedColumns.jpg

My sample file is attached for you to look at.

Helpful resources

Announcements
May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!