cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Transformar - Linhas em Colunas

Pessoal 

 

Poderiam me ajudar com a situação abaixo? Meu relatório apresenta a informação mais relevante como um cabeçalho. Eu preciso transformar esse cabeçalho uma coluna. 

É possível?

Abaixo coloquei um exemplo no excel de como deveria ficar

 

Capturar.PNGCapturar 2.PNG

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Highlighted
Community Support
Community Support

Re: Transformar - Linhas em Colunas

Hi @danielaxavier 

Please check each steps of my queries.

This my end result.

Capture7.JPG

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Transformar - Linhas em Colunas

Hi @danielaxavier 

Is this problem sloved? 
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please feel free to let me know.
 
Best Regards
Maggie

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Transformar - Linhas em Colunas

In edit query, you have the options to remove and even make the first row has row as a header. But looking at the data you need to some clean up in power bi. 

Refer

https://docs.microsoft.com/en-us/power-bi/desktop-shape-and-combine-data



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Community Support
Community Support

Re: Transformar - Linhas em Colunas

Hi @danielaxavier 

Please check each steps of my queries.

This my end result.

Capture7.JPG

 

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

View solution in original post

Highlighted
Community Support
Community Support

Re: Transformar - Linhas em Colunas

Hi @danielaxavier 

Is this problem sloved? 
If it is sloved, could you kindly accept it as a solution to close this case?
If not, please feel free to let me know.
 
Best Regards
Maggie

View solution in original post

Highlighted
Regular Visitor

Re: Transformar - Linhas em Colunas

Olá Resolvido, através da sua tratativa consegui resolver o mesmo problema em vários relatórios!!

muito obrigado

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors
Users online (512)