Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

The question of data transpose

hi all

 

I have a problem with data editing, as shown in the first picture below, which is my basic data

old.png

 

I want to convert it to this picture

In the second image I turned the location column into a row and filled in the values for the next three fields

new.png

 

Can this be solved by M function? If so, thank you very much

 

Best Regards

alan-li

 

1 ACCEPTED SOLUTION
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Based on your basic data, we can achieve your desired output using Matrix Table

2019_09_03_11_12_39_Settings.png

 

If I am not mistaken, M Query cannot have sub column like you wanted on the second column.

View solution in original post

8 REPLIES 8
mussaenda
Super User
Super User

Hi @Anonymous ,

 

Based on your basic data, we can achieve your desired output using Matrix Table

2019_09_03_11_12_39_Settings.png

 

If I am not mistaken, M Query cannot have sub column like you wanted on the second column.

Anonymous
Not applicable

hi @mussaenda 

 

Excuse me I solved the problem.

 

Best Regards

alan-li

Good to know you have solved the problem

Anonymous
Not applicable

hi @mussaenda 

 

I would like to know if I can export the data according to the template of my table

I haven't found the relevant information, please let me know if you know thinks

 

Best Regards

alan-li

Hi @Anonymous ,

 

You cannot.

There is a workaround but it needs time and effort.

If you really wanted to export the matrix style, save first the page in pdf then convert pdf to excel.

 

Anonymous
Not applicable

hi @mussaenda 

 

ok, thinks a lot

 

Best Regards

alan-li

Anonymous
Not applicable

hi @mussaenda 

 

Why is mine displayed like this

Is there something else I need to set up, I just found the drill data

aa.png

 

Best Regards

alan-li

Anonymous
Not applicable

hi @mussaenda 

 

That will do. Thank you very much

 

Best Regards

alan-li

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

Top Solution Authors