Forum Discussion

karthiknpm's avatar
karthiknpm
Regular Visitor
8 years ago

table : Grouping Column header

Dear Team,

 

Im trying to create report with table format.But in table columns having some parent headers (kind of grouping) as below.

 

Could you please suggest. Please suggest some workaround if there is no direct option.

 

Thank you,

 

Regards,

Karthik.K

2 Replies

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

     Hi karthiknpm,

     

    In Power BI, it is not possible to add group headers.

     

    As a workaround, you could unpivot table structure first in Query Editor mode. Then, add a calculated column to group original field names (which are listed in a new single column). Then, use a Matrix visual to display data.

     

    Regards,

    Yuliana Gu

    • karthiknpm's avatar
      karthiknpm
      Regular Visitor
      8 years ago

      Hi,

      Thank for the response.

      Currently I didnt pivoted the columns. all are columns in a table.for designing purpose I had grouped the columns.

      Enclosed the screenshot of table structure.

       

       

      Could you please provide a sample. 

       

      Note: Is there any option to remove column headers in table (not by changing background colour to same colour). By only view the rows .

       

      Regards,

      Karthik.K