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.

Hi Belliappa4218- ,I'm sorry I didn't understand what you meant before. You can try this approach: Best Regards,Dino TaoIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Columns to header | Microsoft Fabric Community

5 Replies

PijushRoy
Community Champion
2 years ago
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-
  Regular Visitor
  2 years ago
  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)
Anonymous
Not applicable
2 years ago
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-
  Regular Visitor
  2 years ago
  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
    Not applicable
    2 years ago
    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.