Forum Discussion

Belliappa4218-'s avatar
Belliappa4218-
Regular Visitor
2 years ago
Solved

Columns to header

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....
General Comment
  • Anonymous's avatar
    Anonymous
    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.

     

Anonymous's avatar
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-'s avatar
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's avatar
    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.