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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
martaTr
Frequent Visitor

how to add a new row / header to my table

hi! i've seen already many similar posts about that issue, but none of them fully respond to the query, 

i've uploaded a table from an Excel. as you can see on the below screenshot i need a header to them, i tried to create a new table and merge them (not sure why instead of merging i have additional columns next to exsiting ones).  Do you have any idea how can i do it? i tried to add a column and transpose but that didnt work netiher

thank you!

 

martaTr_0-1664283386968.png

 

3 REPLIES 3
vanessafvg
Super User
Super User

its not really clear what you are asking, can you please provide what you are trying to do by giving an example. 





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




hi, i need something as below , otherwise i'am not really sure how can i use above table in my dashboard.it's not possibile to put them in Card element. Once i willl have two columns i can put theirs element in Cards, giving information to the enduser of my dashboard. 

martaTr_0-1664352651608.png

 

so are you saying you need to push the header column into a row?    can you share your file?   you have opted to use your first line as the header, remove that step from your steps.  Can you share the code in your advanced editor in power query?





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.