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

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

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
Super User IV
Super User IV

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

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

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

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!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors