table : Grouping Column header

[karthiknpm]

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

[v-yulgu-msft]

 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]

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