cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
karthiknpm Frequent Visitor
Frequent Visitor

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.table.jpg

 

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

 

Thank you,

 

Regards,

Karthik.K

2 REPLIES 2
Microsoft v-yulgu-msft
Microsoft

Re: table : Grouping Column header

 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

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
karthiknpm Frequent Visitor
Frequent Visitor

Re: table : Grouping Column header

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.

 

table.jpg

 

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

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Microsoft Implementation for Communities Wins Award

Microsoft Implementation for Communities Wins Award

Learn about the award-winning innovation that was implemented across Microsoft’s Business Applications Communities.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Kudoed Authors (Last 30 Days)
Users online (2,228)