Columns to header

[Belliappa4218-]

• Hi # everyone. I want to display the column name as header for example table1 contains surgical extractions it contains values .my requirement to display the column as header in table visualization.

[Anonymous]

Hi @Belliappa4218- ,

I can provide you with two solutions:

First solution:
In Power Query, select the column you want to turn into a header and click Transpose.

Second solution:
Choose to use a matrix instead of a table when creating visual objects.

Put the columns that need to be turned into headers directly into Columns.

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Belliappa4218-]

Hello, I would like the output to resemble the format in the first screenshot. However, my data is structured similarly to the second screenshot. Could you please advise me on how to convert the values from columns into row headers as per my requirements.
1)

2)

attched screenshot 

[Anonymous · Accepted solution]

Hi @Belliappa4218- ,

I'm sorry I didn't understand what you meant before. You can try this approach:

Best Regards,
Dino Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[PijushRoy]

Hi @Belliappa4218- 

Please share screenshot of the issue

Please show the expected outcome based on the sample data you provided. Find how to provide sample data
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

How to get answered quickly
https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523

[Belliappa4218-]

Hello, I would like the output to resemble the format in the first screenshot. However, my data is structured similarly to the second screenshot. Could you please advise me on how to convert the values from columns into row headers as per my requirements.
1)

2)