Forum Discussion

gabf48's avatar
gabf48
Regular Visitor
7 years ago
Solved

Vertical Table

Hy,   It is possible in to insert a vertical table?   So I have a table like that: http://prntscr.com/l9eeva And I want insert the value like that: http://prntscr.com/l9ef1v  
  • v-yuta-msft's avatar
    v-yuta-msft
    7 years ago

    Hi gabf48,

     

    The data type in one column is same so I'm afraid different types can't be permitted in one column after be display on verticle. 

     

    Regards,

    Jimmy Tao

PattemManohar's avatar
PattemManohar
Community Champion
7 years ago

gabf48 Please select all columns and use "Unpivot Columns" in "Power Query Editor"

 

  • gabf48's avatar
    gabf48
    Regular Visitor
    7 years ago

    It is not ok. I lost the type of columns. I want to keep the information from table, but I want to display on vertical in the dashboard. 

    • v-yuta-msft's avatar
      v-yuta-msft
      Community Support
      7 years ago

      Hi gabf48,

       

      The data type in one column is same so I'm afraid different types can't be permitted in one column after be display on verticle. 

       

      Regards,

      Jimmy Tao

    • PattemManohar's avatar
      PattemManohar
      Community Champion
      7 years ago

      gabf48 It's not possible to have mixed datatypes for single field (different data types for different rows in same field)