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 workarou...
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