Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

convert table headers

Hi,

 

I have a table1 mentioned below, i need the list of table headers as a dropdown list.

 

 

REgards,

Varun

Need Help
  • v-yulgu-msft's avatar
    v-yulgu-msft
    7 years ago

    Hi Anonymous ,

     

    Select all column headers expect for [TABLE1] and click "Unpivot columns".

     

    Drag [Column Type] into a slicer, and use a Matrix to display above table.

    Best regards,

    Yuliana Gu

1 Reply

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Microsoft Employee
    7 years ago

    Hi Anonymous ,

     

    Select all column headers expect for [TABLE1] and click "Unpivot columns".

     

    Drag [Column Type] into a slicer, and use a Matrix to display above table.

    Best regards,

    Yuliana Gu